Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hit enter in any column and go to next row in first column
I want a macro so that when I hit {enter} the curser goes to the next row in
the first column. I am not interested in doing this for the hole workbook, just one sheet. I know about "tab tab tab enter", but sometimes I use arrows to move between columns. I fill in columns from B to AZ, but sometimes not all of them. I need to be able to hit enter in column D or column Z or any column and have the curser go to column A in the next row. Protecting cells will not work ({enter} only goes to the next unprotected cell in the same column). Thank You! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for going to next row first column on enter | Excel Discussion (Misc queries) | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
enter date in column a and amount in column d | Excel Discussion (Misc queries) | |||
when I enter 12.50 in a column, it automatically changes to 13? | Excel Worksheet Functions | |||
HOW DO I ENTER A NAME WHERE IT SAYS COLUMN A - Z, IT SAYS INVALID | Excel Discussion (Misc queries) |