Double Click A Formula Jumps to Cells

[Gian624]

Hello Everyone,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a strange thing going on. If I double click on a formula, I would expect the formula to be displayed in the formula box at the top and the cells being referenced to be in different colors on the formula. However, all of a sudden when I double click on a formula, it automatically jumps to the cells that were part of the formula and looks like it control selects them without displaying the formula in the formula box. Any thoughts on how to get back to the original way?
<o></o>
Thank you all so much,
Matt

 

[hallingh]

I'm not sure, but one guess is:

Go to Excel Options > Advanced And under Editing Options make sure "Allow Editing Directly In Cell" is checked.

Hope this helps.

Hank

 

[Gian624]

Thanks Hank, that will do it. I appreciate it much