How to restore F2 functions

  • Thread starter Thread starter Zipdisk
  • Start date Start date
Z

Zipdisk

Lately, I am unable to outline, when entering edit mode in a cell, the
cell's formula-related 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 may be restored?
 
You can see the highlighted cell refs either in the formula bar or in the cell

depending upon the settings at Tools>Options>Edit>Edit Directly in Cell.


Gord Dibben MS Excel MVP
 
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?
 
Back
Top