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

[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!

 

[Bob Umlas]

Before pressing an arrow, press the F2 key (putting you in Edit mode).
Bob Umlas
Excel MVP

 

[pickytweety]

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

Before pressing an arrow, press the F2 key (putting you in Edit mode).
Bob Umlas
Excel MVP

 

[T. Valko]

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!

 

[Rick Rothstein]

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)

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!