ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   After Enter, go to correct cell (https://www.excelbanter.com/excel-discussion-misc-queries/148825-after-enter-go-correct-cell.html)

ClaireView

After Enter, go to correct cell
 
I may be crazy, but it seems to me that after I hit Enter, my cursor USED to
go down a row and to the column that I first filled in. Does that make
sense? If I filled in A1, B1, C1, D1, and E1 and then hit Enter, it would
move to A2. Now it doesn't. I can't figure out how to make it do what I
want. Can anyone help?

I'm using Excel 2002 SP1. Thanks.

Bob Phillips

After Enter, go to correct cell
 
ToolsoptionsEdit and check the Move selection after Enter box and set the
direction.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ClaireView" wrote in message
...
I may be crazy, but it seems to me that after I hit Enter, my cursor USED
to
go down a row and to the column that I first filled in. Does that make
sense? If I filled in A1, B1, C1, D1, and E1 and then hit Enter, it would
move to A2. Now it doesn't. I can't figure out how to make it do what I
want. Can anyone help?

I'm using Excel 2002 SP1. Thanks.




Peo Sjoblom

After Enter, go to correct cell
 
If you after entering data in A1, B1 etc use the tab key to move to the next
cell to the right it will do as you remember when you press enter. If
nothing happens when you press enter then go into toolsoptionsedit and
check "Move selection after enter"


--
Regards,

Peo Sjoblom



"ClaireView" wrote in message
...
I may be crazy, but it seems to me that after I hit Enter, my cursor USED
to
go down a row and to the column that I first filled in. Does that make
sense? If I filled in A1, B1, C1, D1, and E1 and then hit Enter, it would
move to A2. Now it doesn't. I can't figure out how to make it do what I
want. Can anyone help?

I'm using Excel 2002 SP1. Thanks.




ClaireView

After Enter, go to correct cell
 
Aha! Using the Tab key was the answer. For what I was doing, it made more
sense to use the arrow keys, so the Enter wasn't working correctly. I tried
it using the Tab key and it worked just like I remember. Thanks for your
help, this was driving me crazy!

"Peo Sjoblom" wrote:

If you after entering data in A1, B1 etc use the tab key to move to the next
cell to the right it will do as you remember when you press enter. If
nothing happens when you press enter then go into toolsoptionsedit and
check "Move selection after enter"


--
Regards,

Peo Sjoblom



"ClaireView" wrote in message
...
I may be crazy, but it seems to me that after I hit Enter, my cursor USED
to
go down a row and to the column that I first filled in. Does that make
sense? If I filled in A1, B1, C1, D1, and E1 and then hit Enter, it would
move to A2. Now it doesn't. I can't figure out how to make it do what I
want. Can anyone help?

I'm using Excel 2002 SP1. Thanks.






All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com