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


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

Advertisements

B

Bob Umlas

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

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


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

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

Advertisements

R

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)


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!
 

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

Top