| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
![Bob Umlas[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
