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 1
Permanently link formula references to Column Names and not Column Cell Numbers 1
AutoFill double click does not work in Excel 2007 2
Double click fails to run the code, just selects the cell 12
Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell) 4
Formulas on double click 5
My conditional formatting evaluates only when I double click cells 0
Dynamic Cell References in Excel 2

Top