Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
cannot enter correct numbers in cells | Excel Worksheet Functions | |||
how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) | |||
Enter CORRECT password, file doesn't come up? Help | Excel Worksheet Functions | |||
Only using the correct cell for the sum | Excel Worksheet Functions |