#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nicole
 
Posts: n/a
Default Protect Area

How do I protect a certain area in an excel worksheet without interferring
with the rest of the document?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
shrink excel chart area mcarrington Excel Discussion (Misc queries) 0 January 5th 06 08:57 PM
Extra Row in Defined Print Area Harry Gordon Excel Discussion (Misc queries) 3 November 14th 05 03:06 AM
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
Resize chart area without resizing plot area Janwillem van Dijk Charts and Charting in Excel 2 August 2nd 05 01:52 AM
Volatile print area stevepain Excel Discussion (Misc queries) 6 July 20th 05 05:46 PM


All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"