And if they just made it so some of those dialogs could be resized, life would
be simpler, too!

Dallman Ross wrote:

In , Dave Peterson
spake thusly:

This F2 toggle works nice in lots of dialogs.

Wow. I never knew about that. The dang arrow keys have
been messing me up in the formula bar for years. Thanks!

-dman-

==============================================
If you're editting a cell and then hit the arrow keys, you may
get this. Excel likes to help you build formulas and allows you
to point at other cells (instead of typing the addresses).

Try this: type = in an empty cell Look at the bottom left corner
of the statusbar.

If you see Enter, try using the arrow keys and watch what
happens.

Now try it again. type = and then hit F2. Notice what is
displayed in the statusbar. You should be toggling between Enter
and Edit. When in Edit mode, you can use the arrows to move
around in the existing formula.

This F2 toggle works nice in lots of dialogs.

Ken wrote:

When typing text in a cell I use arrows to go to the next
cell and it creats a reference as in a formula. The text
doesn't start with anything to make this a formula. Any one
know what I did to make this happen? Thanks in advance

--

Dave Peterson