• Home
  • About Pioneer Training
  • Database Programming
  • Training
  • VBA Programming
  • Web Development

Locking Part of an Excel Spreadsheet

Posted by: Mannie on: November 11 2005 • Categorized in: Excel

This is a situation that often comes up in our Excel classes:

“I need to add data to my spreadsheet, but I want to lock the cells that contain formulas so they don’t get overwritten.”

It’s easy to Protect an entire spreadsheet from the Tools | Protection | Protect Sheet… menu item. However, this option protects all the cells in the spreadsheet.

Unless…you first unlock the cells you want to remain editable. Here’s how:

  1. Select the cells you want to be editable.
  2. Select Format | Cells, and click the Protection tab:
  3. Format Cells - Protection Tab

  4. Clear the check from the Locked checkbox.
  5. Click OK.
  6. Select Tools | Protection | Protect Sheet…
  7. Protect Sheet dialog

  8. Leave all the default items checked. (If you wish, you can add checks to any features you want users to access.) Add a password if you want to prevent a user from Unprotecting the sheet from the Tools menu.
  9. Click OK.
  10. Users will now be able to edit only the cells that are unlocked. If a user tries to edit a locked cell on a protected worksheet, he/she will see the following message:
  11. Excel Protection Message

Share
Tag Search: Excel
Comments: Leave a Comment

Leave a Reply

Click here to cancel reply.

« Are Your Web Images Accessible to Users with Visual Disabilities?
Speed Up E-mail in Outlook »
 

Google Analytics Online Workshop

Learn how to use this amazing free tool to find out a wealth of information about the visitors to your website.

Easy to set up and use.
No technical expertise required.

This is a two-part online class with a live instructor using GoToMeeting.
Your invitation to the class will contain a link to download a guest version of the software before the class starts.

Cost: $198

More Details  |  Register Now!

Tips and Tricks

  • Access (5)
  • Dreamweaver (8)
  • Excel (24)
  • General Comments (6)
  • Google Analytics (3)
  • Office 2007 (8)
  • Office 2010 (19)
  • Office 2013 (2)
  • Outlook (9)
  • PowerPoint (11)
  • Training (1)
  • Visual Basic for Applications (VBA) (2)
  • Web Design (4)
  • Windows (5)
  • Windows 7 (5)
  • Word (25)
Copyright © 2009 All Rights Reserved. Powered by WordPress 2.8 Subscribe to RSS
Theme Design by: Pixel Theme Studio