Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
When using Excel to produce forms, I want to automate how the cells are
selected when inputing data. Usually, I unlock the cells that will have data entered in them and lock the remaing cells. Next, I protect the sheet. Then, I use the tab key to move to the next cell that requires data instead of having to click on the next cell. I'd like to take it a step further. Does anyone know if I can direct Excel to automatically move to the next cell when I enter data in the current cell? These particular cells only have one digit entered in each cell. So, without having to use the tab key, once a digit is entered in a cell, I'd like the next cell to be automatically selected so I can input another digit. Thanks! Larry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
moving from cell to cell | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |