| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop next cell being selected on Enter
I have a sheet which has only 3 input cells, but only one input cell is
required for a user in a given state. I've disabled the "move selection after enter" function in tools/option/edit and when they enter a value and press enter the active cell stays the same - which is what I want. When I protect the sheet, the active cell jumps to the next unprotected cell. How can I stop it doing that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
| How to move to next cell by entering data-not using Enter key. | Excel Discussion (Misc queries) | |||
| How to move to next cell by entering data-not using Enter key. | New Users to Excel | |||
| how read value from last selected cell? It is possible? how get adress last selected cell? | New Users to Excel | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
Threaded Mode
