Double-clicking a formula

  • Thread starter Thread starter Tina
  • Start date Start date
T

Tina

For some reason, when I double-click a formula now,
instead of highlighting the different components of the
formula in different colors, my active cell is jumping
around the worksheet to the components of the formula.

When I look at the Edit menu, the "undo" option shows that
Excel just performed a "goto special" command.

I don't know what caused this to change, but I can't find
a setting to change back to the default. It doesn't
matter if it's a new or existing worksheet. Any ideas?
 
THANK YOU KEN!!! That was driving me nuts!
-----Original Message-----
Tools / Options / Edit Tab/ Edit Directly in cell.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

---------------------------------------------------------- ------------------
Attitude - A little thing that makes a BIG difference
---------------------------------------------------------- ------------------






.
Click to expand...
 
LOL, my pleasure & appreciate the feedback. Gets kinda frustrating at times doesn't it :-)
 
Back
Top