View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Protected work shet

Click TOOLS on the menu and select OPTIONS. In the OPTIONS dialog box, click
the EDIT tab and turn on MOVE SELECTION AFTER ENTER if it isn't on, and set
the DIRECTION to RIGHT.

If you're using Excel 2000 or greater you can also set protection to only
allow users to move to unprotected cells.
--
Kevin Backmann


"Stuart Carnachan" wrote:

I have a proteced work sheet with unlocked cells where dat should be input.
Is there any to ebsure the cells are entered in descending/horizontal order
--
Stuart