formula reference cells in color

R

Richard Garneau

I am not sure why it doesn't do it now (Excel must have decided on
it's own to turn it off!!!!).

If I have a formula existing in a cell, I move to the cell and press
F2, the formula cell references should show in color with the
referenced cells being in the same color.

Why isn't it working?

Thanks so much,

Richard Garneau
 
J

JE McGimpsey

Richard Garneau said:
I am not sure why it doesn't do it now (Excel must have decided on
it's own to turn it off!!!!).

If I have a formula existing in a cell, I move to the cell and press
F2, the formula cell references should show in color with the
referenced cells being in the same color.

Why isn't it working?
Click to expand...

F2 in Mac XL doesn't enter Edit Mode, unless you do something like this:

http://www.mcgimpsey.com/macoffice/excel/f2.html

The MacXL keyboard shortcut is CTRL-u.
 
Top