View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael M Michael M is offline
external usenet poster
 
Posts: 118
Default 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.