| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 cell references - 32 refs - no more highlighting?
I just got upgraded to Vista and Excel 2003, however one fluke has appeared.
If I reference more than 32 cells within a formula and I hit F2 to edit the formula, I lose the (previously known) highlighting function, i.e., prior to this, all the referenced cells would be higlighted in different colors. Is there some new option I have to select to enable this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 cell references - 32 refs - no more highlighting?
Has nothing to do with upgrading.
Excel has a 30 argument limit so anything over that won't be highlighted. Gord Dibben MS Excel MVP On Tue, 30 Jun 2009 07:04:02 -0700, TimK wrote: I just got upgraded to Vista and Excel 2003, however one fluke has appeared. If I reference more than 32 cells within a formula and I hit F2 to edit the formula, I lose the (previously known) highlighting function, i.e., prior to this, all the referenced cells would be higlighted in different colors. Is there some new option I have to select to enable this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 cell references - 32 refs - no more highlighting?
This didn't happen with Excel in Windows XP
"Gord Dibben" wrote: Has nothing to do with upgrading. Excel has a 30 argument limit so anything over that won't be highlighted. Gord Dibben MS Excel MVP On Tue, 30 Jun 2009 07:04:02 -0700, TimK wrote: I just got upgraded to Vista and Excel 2003, however one fluke has appeared. If I reference more than 32 cells within a formula and I hit F2 to edit the formula, I lose the (previously known) highlighting function, i.e., prior to this, all the referenced cells would be higlighted in different colors. Is there some new option I have to select to enable this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 cell references - 32 refs - no more highlighting?
This didn't happen with Excel in Windows XP
Actually, it deos. I only get highlights for 32 references in Excel 2003 under Windows XP. HTH, Bernie MS Excel MVP |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 cell references - 32 refs - no more highlighting?
Yes it did.
After 32(not 30) as I stated. Gord On Tue, 30 Jun 2009 09:09:02 -0700, TimK wrote: This didn't happen with Excel in Windows XP "Gord Dibben" wrote: Has nothing to do with upgrading. Excel has a 30 argument limit so anything over that won't be highlighted. Gord Dibben MS Excel MVP On Tue, 30 Jun 2009 07:04:02 -0700, TimK wrote: I just got upgraded to Vista and Excel 2003, however one fluke has appeared. If I reference more than 32 cells within a formula and I hit F2 to edit the formula, I lose the (previously known) highlighting function, i.e., prior to this, all the referenced cells would be higlighted in different colors. Is there some new option I have to select to enable this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a text highlighting feature in excel 2003? | Excel Discussion (Misc queries) | |||
| Excel 2003 macros set relative cell references | Excel Discussion (Misc queries) | |||
| auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
| Excel 2003-how copy tab w/o file refs? | Excel Discussion (Misc queries) | |||
| returning absolute cell refs | Excel Discussion (Misc queries) | |||
Linear Mode
