Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect Area
How do I protect a certain area in an excel worksheet without interferring
with the rest of the document? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect Area
Highlight all the cells in the worksheet, either by CTRL-A or by
clicking the box intersection of row and column identifiers. Then Format | Cells | Protection tab and uncheck the Locked box. Then select the area which you want to protect and Format | Cells | Protection tab and check the Locked box. Then Tools | Protection | Protect sheet. You can specify a password (twice) if you want to increase the protection. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shrink excel chart area | Excel Discussion (Misc queries) | |||
Extra Row in Defined Print Area | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Resize chart area without resizing plot area | Charts and Charting in Excel | |||
Volatile print area | Excel Discussion (Misc queries) |