Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Locking Individual Cells in Excel 2007

Posted on 2011-04-26
Medium Priority
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
  • 2
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 35467393
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

zorvek (Kevin Jones) earned 1000 total points
ID: 35467425
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

ID: 35467697
Thanks for the quick response!

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

564 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