| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for going to next row first column on enter
-- thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for going to next row first column on enter
There is no formula that will move the cursor. What you can do is to use the
tab key to move to the right. When you get to the end of the columns hit enter. That will take you to the first data entry column of the next row. -- HTH... Jim Thomlinson "jcontrer" wrote: -- thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for going to next row first column on enter
A formula won't affect behavior of the selection. You can define a name
which when branched to (F5) will do that. If you're in cell B3, define a short name, like z, to be =$A4 (note the "$"). If you finish entering data in cell J5, then if you F5 to z you'll be in A6. HTH "jcontrer" wrote in message ... -- thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to enter names in a column specific # of times | Excel Worksheet Functions | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| How do I enter a Formula for entire column? | Excel Worksheet Functions | |||
| enter formula once for entire column | Excel Worksheet Functions | |||
| how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
Linear Mode
