Protected work shet

S

Stuart Carnachan

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
 
K

Kevin B

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.
 
S

Stuart Carnachan

kevin

Easy when you know how. Thanks
--
Stuart


Kevin B said:
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.
Click to expand...
 
Top