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.

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.

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.

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.