double click cell to show formula references

G

goofy11

I often double click on cells to show the formula references highlighted with
different border colors. I occasionally have to use a certain computer that
has this option alterered. On this computer when I double click a formula,
it selects all the cell references, rather than highlighting them with the
colored borders. Does anyone know how to change this back? It is maddening!

Jeff
 
J

Jim Rech

Double-click behavior is determined by the "Edit directly in cell" setting
under Tools, Options, Edit.

--
Jim
|I often double click on cells to show the formula references highlighted
with
| different border colors. I occasionally have to use a certain computer
that
| has this option alterered. On this computer when I double click a
formula,
| it selects all the cell references, rather than highlighting them with the
| colored borders. Does anyone know how to change this back? It is
maddening!
|
| Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatically show cell references of formulas 2
View cell references 1
Dynamic Cell References in Excel 2
Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell) 4
Value won't show correctly in cell unless I double click formula, 1
Double Click to see formula source data? Set up? 3
Change All Instances of a Cell Reference in a Formula 5
Turn off the formula correction feature 4

Top