How To Protect an Excel Spreadsheet

04 Jan 2012 by Phil Beach
Posted in: The Point

Trouble viewing the screencast at work? Try signing up for The Point on our home page with your personal email address and watch the screencast from home.

Protect the Entire Sheet

Sometimes it is necessary to restrict editing rights of an Excel worksheet. FollowAlong with these steps to learn how:

1. Open the Excel worksheet you wish to protect
2. Click File
3. Select Protect Workbook

   

4. Choose the appropriate type of restriction
5. Follow any additional instructions

Partial Protection

Sometimes it's necessary to leave part of the worksheet unprotected, while at the same time protecting the rest. FollowAlong with these steps:

1. Select the cells you wish to remain unprotected
2. Right-click one of the cells you have selected and choose Format Cells...

   

3. Under the Protection tab, uncheck Locked

   

4. Click OK
5. Follow the above steps to protect the rest of the worksheet. The cells you have modified here will remain unprotected

If you have an unanswered technical question that you would like to see appear in an upcoming issue of The Point, feel free to call or email it to .(JavaScript must be enabled to view this email address) - 973.448.0070 ext. 323.

SEARCH

Select Category Community Development IBM Linux Magazine IT Support The Point Videos

Select Month March 2012 February 2012 January 2012 December 2011 November 2011 October 2011 August 2011 July 2011 June 2011 May 2011 April 2011 March 2011 February 2011 January 2011 December 2010 November 2010 October 2010 September 2010 August 2010 July 2010 June 2010 May 2010 April 2010 March 2010 February 2010 January 2010 December 2009 November 2009 October 2009 September 2009 August 2009

Select Author Phil BeachFrank AblesonBarry McGuire

HOW TO VIDEOS

Creating Contact Groups in Google Apps and Gmail

How To Setup Filters in Google Apps & Gmail