Arrow key creats reference
 

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

Arrow key creats reference
 

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

Arrow key creats reference
 

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.

"Dave Peterson" wrote:

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

Arrow key creats reference
 

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

Arrow key creats reference
 

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

Arrow key creats reference
 

What happened to "Point" when editing a cell?

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


Gord

On Thu, 02 Nov 2006 18:19:25 -0600, Dave Peterson
wrote:

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

Arrow key creats reference
 

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

Gord Dibben wrote:

What happened to "Point" when editing a cell?

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

Gord

On Thu, 02 Nov 2006 18:19:25 -0600, Dave Peterson
wrote:

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