Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to lock 2 rows in a sheet
Hi All,
Please help me out with the steps to lock 2 specific rows in a sheet. All other rows should have full access for all users and only 2 specific rows should be given with read access.. I tried, All cells were formatted with no locked option 2 rows which require read only access was selected with locked formatting Then chose protect workshhet with password But this one locks the entire worksheet PLz help.. With Regards, Sivaji |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to lock 2 rows in a sheet
You'll have to lock the cells that you want locked and unlock the cells that
should not be locked. Unless you've done something different, the default is locked for each cell. Then you'll have to protect the worksheet -- else the lockedness of each cell won't matter. And depending on the version of excel, you'll be able to set the granularity of what kind of changes can be made to these unlocked cells. You'll see those options in the protect sheet dialog. Be aware that there are lots of things that can't be done on a protected worksheet. If you have trouble, you may want to be more specific about what version of excel you're using and how each row/cell should be locked (what should be allowed and what shouldn't). On 03/30/2011 01:12, siva wrote: Hi All, Please help me out with the steps to lock 2 specific rows in a sheet. All other rows should have full access for all users and only 2 specific rows should be given with read access.. I tried, All cells were formatted with no locked option 2 rows which require read only access was selected with locked formatting Then chose protect workshhet with password But this one locks the entire worksheet PLz help.. With Regards, Sivaji -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to compress rows and lock rows | Excel Discussion (Misc queries) | |||
lock column size for some rows and resize for other rows. | Excel Discussion (Misc queries) | |||
Lock rows together | Excel Discussion (Misc queries) | |||
Is there a way to lock two or more rows together? | Excel Worksheet Functions | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions |