Auto Navigate Cells
Aaron
Highlight the cells that you want the user to use, go to
Format/cells/protection and uncheck the box.
Then protect the sheet and tell the user to use TAB to move around the sheet.
It will then only go to the unprotected cells.
HTH
Michael M
"Aaron" wrote:
Hi,
Is it possible to make excel spreadsheet automatically snap to cells or
jump around the spreadsheet when enter (return key) is pressed rather
than just going down one cell?
I would like the user to have to only enter data then return key and it
goes to next cell somewhere else and then enter data and return key
etc.
TIA,
Aaron.
|