How to restore F2 functions

[Zipdisk]

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.

 

[Jaleel]

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

 

[Gord Dibben]

Only if Edit Directly in Cell is enabled.


Gord Dibben MS Excel MVP

 

[Zipdisk]

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?

 

[Jaleel]

Hi Gord,

Thanks for your additional information. I was not aware of that.

Regards,

Jaleel