Locking Individual Cells in Excel 2007

Posted on 2011-04-26
Last Modified: 2013-11-05
Is there an easy way to lock specific cells within an excel workbook? I’ve got one w 8 sheets or so and just want to highlight the cells I want to lock and lock them. Ive searched online some and followed the steps but it doesn’t seem to work. I can lock the whole sheet easily, but not just certain rows and stuff. If there’s an easy step by step, please let me know.

Question by:StumpedAndGrateful
    LVL 81

    Expert Comment

    by:zorvek (Kevin Jones)
    You have to protect the worksheet to protect any cells. That means unprotecting the cells you want to be unprotecting versus protecting the cells you want protected.

    Select the whole sheet and unprotect the cells. Then select the cells you want protected and protect them. Then set worksheet protection on.

    LVL 81

    Accepted Solution

    More details. A worksheet can be protected in such a way that only cells that need to be changed can be changed. Protecting a worksheet involves two different settings or attributes: worksheet protection and cell locking. When a worksheet is protected, all cells that are locked become uneditable and those cells that are not locked remain editable. To lock or unlock a cell, select the cell or cells and choose the menu command Format->Cells (in Excel 2007 press ALT, O, E), navigate to the Protection tab, and check the Locked check box on to lock the cell or cells or off to unlock. Note that on all new worksheets all cells default to being locked.

    To protect a worksheet, choose the menu command Tools->Protection->Protect Sheet (in Excel 2007 and later navigate to the Review tab and click Protect Sheet in the Changes group or press ALT, T, P, P). Click OK to lock the worksheet without a password. To protect the worksheet with a password in order to prevent others from unprotecting it, enter a password. Other settings on the Protect Sheet dialog provide the ability to prevent or allow other functions such as selecting locked cells, sorting, filtering, deleting and inserting rows and columns, formatting cells, etc. Note that most of these settings are only available in Excel 2002 and later.

    To unprotect a worksheet, choose the menu command Tools->Protection->Unprotect Sheet (in Excel 2007 and later navigate to the Review tab and click Unprotect Sheet in the Changes group). If the worksheet is password protect a password will have to be entered to complete the unprotection.

    To prevent the user from viewing formulas while the worksheet is protected, before protecting it select the cells for which the formulas need to be hidden, choose the menu command Format->Cells (in Excel 2007 and later navigate to the Home tab and select Format Cells from the Format menu in the Cells group or press ALT, O, E), navigate to the Protection tab, and check on the Locked and Hidden check boxes.


    Author Closing Comment

    Thanks for the quick response!

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now