Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected work shet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected work shet
kevin
Easy when you know how. Thanks -- Stuart "Kevin B" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Web Queiries should work with protected web sites. | Excel Worksheet Functions | |||
Why does this Formula work? | Excel Worksheet Functions | |||
How to prevent warning messages on protected work sheet. | Excel Worksheet Functions | |||
Tab key don't work in unprotected cells in a protected sheet | Excel Discussion (Misc queries) | |||
Autofilter on protected work book? | Excel Discussion (Misc queries) |