General

speak cells
One of the grandkids was on my computer. Now all of my Office 2007 Excel cells "speak" when entering date and hitting enter. How can I turn this off? -- Davey O. ... 25 Mar 2010 15:02

How can I test for nulls within a range without specifying eac
Excellent, that's a much more efficient way of doing things. Thanks!! "Dave Peterson" wrote: =counta(a5:a12) will return the number of non-empty cells in A5:A12 -- even if the cells contain formulas that evaluate to "" (empty strings). So =if(counta(a5:a12)=0,"All 8 cells are empty","At lea... 25 Mar 2010 15:02

How many entries can Excel handle!?
I have close to 1000 entries in my Excel spreadsheet, and am trying to figure out why entries are coming up missing. I often do custom sorts. This may be when entries get tossed out? ... 26 Mar 2010 03:36

Function to determine if a cell contains a formula
In excel 2007, is there a formula to determine whether or not a cell contains a formula? Basically I want to do and If/Then function that will return a certain answer if a cell contains a formula and will return a different answer if the cell only contains text (that was manually entered in). Thank you. Doub... 25 Mar 2010 15:02

saving macro from workbook to Personal Macro Workbook
I have a macro saved to a workbook, let's call it Data.xls. I would like this macro saved to my personal macro workbook so it can be available anytime without having to open Data.xls so I can use this macro. How can I do this? I am new to working with macros. Any help will be appreciated! ... 25 Mar 2010 15:02

xlt start book
I opened the xlt file in my start folder and added a defined name. I must have done something else because now whenever my Excel 2003 opens it gives me the Microsoft Excel 4 macro warning before it loads Book1. After Book1 loads (either enabling the macros or not), I look for the macro and cannot find it. Ho... 25 Mar 2010 13:50

Validation dropdown list is not available
Hi, I have XP and 2003. Here's my problem: I vae defined to one column validation. As I select one of the cells, the dropdown list does not come available as usually. I have had once before the same, but I cannot remember how it can be resolved. I have tried to make correction with another file. Creating colum... 25 Mar 2010 16:16

Linking columns for auto fill
Can I link two columns to auto fill Column A when corresponding data is entered in Column B? ... 25 Mar 2010 16:16

Visual Fox Pro export to Excel
How do I export a Visual Fox Pro file into an Excel workheet? ... 25 Mar 2010 16:16

How can I set the show/hide default for comments in Excel?
I want to set the default for all comments in any Excel spreadsheets I create so that they always show rather than hide. Right now, each time I create a comment (which is often), they're always hidden, and I have to manually change them to show each time. ... 25 Mar 2010 12:40