View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IanC[_2_] IanC[_2_] is offline
external usenet poster
 
Posts: 157
Default want to automatically skip certain cells when you hit enter

I don't think you can do this. However, you CAN arrange to skip cells when
you hit TAB.

Select the cells you want accessible, then go to Format Cells
Protection, uncheck Locked and click OK (or hit enter).
Go to Tools Protection Protect Sheet, enter a password if required, then
click OK.

Hitting Tab will skip to the next unlocked cell (working along rows, then
down). Also the only cells where data can be edited are the unlocked ones.

--
Ian
--
"Deedarling1960" wrote in message
...