Edit the rule description-how can u see a long formula in its enti

  • Thread starter Thread starter pickytweety
  • Start date Start date
P

pickytweety

Ok, this is driving me crazy--a sure sign that there has to be a better way.
While using Conditional Formatting, under the Edit Formatting Rule box there
is another box called "Edit the rule description". The problem is that if
you have a long formula in that box, it's really hard to navigate the
formula. When I want to see the end of the formula, I click in the box, but
when I arrow over (hoping to see the end) it automatically inserts a cell
reference into the middle of the formula. How are you supposed to navigate
these long formulas? All I want to do is see the whole thing on screen at
once, but I can't figure out how. AAARGH!
 
Before pressing an arrow, press the F2 key (putting you in Edit mode).
Bob Umlas
Excel MVP
 
Thank you SO much. No more cell references! Is there a way to see the whole
formula all at once? It's not letting me expand the box.
--
Thanks,
PTweety


Bob Umlas said:
Before pressing an arrow, press the F2 key (putting you in Edit mode).
Bob Umlas
Excel MVP
Click to expand...
 
Ah, don't you just love Excel?

LOL!

Makes you want to yell, don't it? Go ahead, it's ok. I've done it many
times.

For the life of me, I don't understand why they (the Excel developers)
thought this behavior was a *good idea*.

F2 to the rescue!

*Before* you start using the directional arrows to navigate the formula hit
function key F2. You won't always remember to do this, though!
 
I have personally yelled many times over this. And I agree with you... what
could they possibly have been thinking in implementing the editing this way?
And why haven't they changed it to default to the more logical editing mode
the F2 changes it to? At the very least, why not add an option to the
Tools/Options palette allowing the user to default it to the method of their
choice?

--
Rick (MVP - Excel)


T. Valko said:
Ah, don't you just love Excel?

LOL!

Makes you want to yell, don't it? Go ahead, it's ok. I've done it many
times.

For the life of me, I don't understand why they (the Excel developers)
thought this behavior was a *good idea*.

F2 to the rescue!

*Before* you start using the directional arrows to navigate the formula
hit function key F2. You won't always remember to do this, though!
Click to expand...
 
Back
Top