Arrow key creats reference

K

Ken

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
 
D

Dave Peterson

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.
 
K

Ken

I'm dumber than a bag of hammers! I use the F2 all the time, in access, so I
know what you are talking about, but your response made me look at the
descriptions at the bottom. This wasn't my computer, so I wasn't using it
all the time to see that the SCROLL LOCK WAS ON! I know what the scroll lock
does when you are not editing a cell, but I've never used it while typing.
Thanks for the response to make me open my eyes.
 
D

Dallman Ross

Dave Peterson said:
This F2 toggle works nice in lots of dialogs.
Click to expand...

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

-dman-

==============================================
 
D

Dave Peterson

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

Gord Dibben

What happened to "Point" when editing a cell?

What was last version to have that toggled on/off using F2?


Gord
 
D

Dave Peterson

I don't know.

I don't see it in xl2003 and don't remember (sigh) about the earlier versions.

It's hell to get old(er).
 
Top