How to restore F2 functions

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?
 
G

Gord Dibben

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
 
Z

Zipdisk

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to restore F2 functions 4
Cells no longer highlighted in XL2003 edit mode? 2
Using the F2 key in excel. 3
How to automatically trigger the vba coding by opening worksheet? 4
How to automatically activate VBA coding within worksheet? 3
Edit: See referenced cells 2
LOST MY FILL COLORS IN EXCEL 2003, HOW TO RESTORE? 3
How to remove validation on entering - into a cell. 1

Top