Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set the column that excel returns to when I hit Enter?
When I am done entering info on one line and hit Enter/Return sometimes it
goes to the next row in column A and sometimes it goes to another cell in the next row. There doesn't seem to be any rhyme or reason to it. Is there a way to set it return where you want? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set the column that excel returns to when I hit Enter?
Tools - Options - Edit tab
You can choose "Move Selection after enter is pressed" and choose which direction. If you want to move differently depending on what cell you are in, you'll have to get in to VBA to capture the Enter keypress and move the cursor appropriately. John Camille wrote: When I am done entering info on one line and hit Enter/Return sometimes it goes to the next row in column A and sometimes it goes to another cell in the next row. There doesn't seem to be any rhyme or reason to it. Is there a way to set it return where you want? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set the column that excel returns to when I hit Enter?
Go to "Tools" - "Options" - Pick the "Edit" tab, Check the box by "Move
selection after Enter" and pick your direction. -- Alan L "Camille" wrote: When I am done entering info on one line and hit Enter/Return sometimes it goes to the next row in column A and sometimes it goes to another cell in the next row. There doesn't seem to be any rhyme or reason to it. Is there a way to set it return where you want? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |