Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to restore F2 functions
Lately, I am unable to display, when entering edit mode in a cell, the
cell's formula-referenced cells. I used to, upon pressing F2, see a cell's formula and, highlighted in differing colors, the cells referenced by the formula to be edited/viewed. Any ideas how this very useful feature, highlighting the formula's referenced cells, may be restored? F2 still gets me into edit mode, but I can no longer see which cells are referenced by the selected cell's formula. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to restore F2 functions
Hi,
I don't know how you lost this F2 feature. But you can double click the formula cell to see which cells are referenced. Regards, Jaleel "Zipdisk" wrote: Lately, I am unable to display, when entering edit mode in a cell, the cell's formula-referenced cells. I used to, upon pressing F2, see a cell's formula and, highlighted in differing colors, the cells referenced by the formula to be edited/viewed. Any ideas how this very useful feature, highlighting the formula's referenced cells, may be restored? F2 still gets me into edit mode, but I can no longer see which cells are referenced by the selected cell's formula. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to restore F2 functions
Only if Edit Directly in Cell is enabled.
Gord Dibben MS Excel MVP On Thu, 21 Sep 2006 07:27:01 -0700, Jaleel wrote: Hi, I don't know how you lost this F2 feature. But you can double click the formula cell to see which cells are referenced. Regards, Jaleel "Zipdisk" wrote: Lately, I am unable to display, when entering edit mode in a cell, the cell's formula-referenced cells. I used to, upon pressing F2, see a cell's formula and, highlighted in differing colors, the cells referenced by the formula to be edited/viewed. Any ideas how this very useful feature, highlighting the formula's referenced cells, may be restored? F2 still gets me into edit mode, but I can no longer see which cells are referenced by the selected cell's formula. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to restore F2 functions
F2 or double-clicking in the cell...
I USED to be able to see the highlighted cells and the formula, but with or without Edit Directly in Cell enabled, and the formula displayed in the cell, referenced cells are no longer highlighted... Any ideas how to restore the cell highlighting? On Thu, 21 Sep 2006 07:27:01 -0700, Jaleel wrote: Hi, I don't know how you lost this F2 feature. But you can double click the formula cell to see which cells are referenced. Regards, Jaleel "Zipdisk" wrote: Lately, I am unable to display, when entering edit mode in a cell, the cell's formula-referenced cells. I used to, upon pressing F2, see a cell's formula and, highlighted in differing colors, the cells referenced by the formula to be edited/viewed. Any ideas how this very useful feature, highlighting the formula's referenced cells, may be restored? F2 still gets me into edit mode, but I can no longer see which cells are referenced by the selected cell's formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions |