Formula Cell Reference Colour Box GONE!!!

[andernos]

I do alot of formula validation etc.

One of the functions I used alot was double clicking on a cell with a formula and it would show the reference cells with little coloured boxes around them....

Recently I have lost this functionality, I miss it... any idea how to turn it back on????

HELP!

 

[SydneyGeek]

Try either of these --

Hit the F2 key to go into rangefinder mode
Go to Tools | Options. In the Edit tab, make sure that Edit Directly In Cell is checked

Denis

 

[andernos]

it kinda works, but my excel must be buggy it keeps not doing it on the double click even though its ticked in the options/edit thing
Whaaa!