View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Zipdisk Zipdisk is offline
external usenet poster
 
Posts: 4
Default 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.