First  |  Prev |  Next  |  Last
Pages: 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234
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
First  |  Prev |  Next  |  Last
Pages: 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234