How to Lock Cells in Excel

Download Article

Explore this Article

methods

1 Locking and Protecting Cells in Excel 2007 and Excel 2010

2 Locking and Protecting Cells: Excel 2003

Other Sections

Questions & Answers

Video

Tips and Warnings

Related Articles

References

Article Summary

Author Info

Last Updated: October 25, 2022

Download Article

Locking cells in an Excel spreadsheet can prevent any changes from being made to the data or formulas that reside in those particular cells. Cells that are locked and protected can be unlocked at any time by the user who initially locked the cells. Follow the steps below to learn how to lock and protect cells in Microsoft Excel versions 2010, 2007, and 2003.

To learn how to unlock the cells, read the article How to Open a Password Protected Excel File.

Things You Should Know

• In all versions of Excel, highlight and right click your cells. Then, select "Format Cells" > "Protection." Check "Locked" and save.
• In Excel 2007 and 2010, go to "Review" > "Changes/Protect Sheet" > "Protect worksheet and contents of locked cells." Type a password click through the prompts to save.
• In Excel 2003, go to "Tools" > "Protection" > "Protect Sheet." Check "Protect worksheet and contents of locked cells." Enter a password and follow the prompts to save.

Steps

Method 1

Method 1 of 2:

Locking and Protecting Cells in Excel 2007 and Excel 2010

Download Article

1. 
   1
   Open the Excel spreadsheet that contains the cells you want locked.
2. 
   2
   Select the cell or cells you want locked.
   Advertisement
3. 
   3
   Right-click on the cells, and select "Format Cells."
4. 
   4
   Click on the tab labeled "Protection."
5. 
   5
   Place a checkmark in the box next to the option labeled "Locked."
6. 
   6
   Click "OK."
7. 
   7
   Click on the tab labeled "Review" at the top of your Excel spreadsheet.
8. 
   8
   Click on the button labeled "Protect Sheet" from within the "Changes" group.
9. 
   9
   Place a checkmark next to "Protect worksheet and contents of locked cells."
10. 
    10
    Enter a password in the text box labeled "Password to unprotect sheet."
11. 
    11
    Click on "OK."
12. 
    12
    Retype your password into the text box labeled "Reenter password to proceed."
13. 
    13
    Click "OK." The cells you selected will now be locked and protected, and can only be unlocked by selecting the cells once again, and entering the password you selected.
Advertisement

Method 2

Method 2 of 2:

Locking and Protecting Cells: Excel 2003

Download Article

1. 
   1
   Open the Excel document that contains the cell or cells you want to lock.
2. 
   2
   Select one or all of the cells you want locked.
3. 
   3
   Right-click on your cell selections, and select "Format Cells" from the drop-down menu.
4. 
   4
   Click on the "Protection" tab.
5. 
   5
   Place a checkmark next to the field labeled "Locked."
6. 
   6
   Click the "OK" button.
7. 
   7
   Click on the "Tools" menu at the top of your Excel document.
8. 
   8
   Select "Protection" from the list of options.
9. 
   9
   Click on "Protect Sheet."
10. 
    10
    Place a checkmark next to the option labeled "Protect worksheet and contents of locked cells."
11. 
    11
    Type a password at the prompt for "Password to unprotect sheet," then click "OK."
12. 
    12
    Reenter your password at the prompt for "Reenter password to proceed."
13. 
    13
    Select "OK." All the cells you selected will now be locked and protected, and can only be unlocked going forward by selecting the locked cells, and entering the password you initially set up.
Advertisement

Community Q&A

Search

Add New Question

• Question

  How do I lock cells in Excel without the whole document becoming read only?

  

  Community Answer

  I suppose you want to lock certain cells instead of the whole sheets. To do that, choose the whole sheet, right click and then select "Format Cells", then "Protection", then uncheck the "Locked" option and click okay. Then select the cells you want to lock, right click and select "Format Cells", then Protection; this time, check the "Locked" option and click okay. Now go back to the main tab, select "Review", then click on "Protect Sheet", and do whatever you want to do with it. Now only the cells you "locked" are protected from editing instead of the whole sheet.

  Thanks! We're glad this was helpful.
  Thank you for your feedback.
  If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow

  Yes No

  Not Helpful 13 Helpful 61
• Question

  How can I protract the single cell while using Excel?

  

  Community Answer

  You cannot protract a single cell in Excel. You can, however, make it appear longer than the rest of the cells around it by "merging" two or more cells together. Highlight the cells you desire and right click. A menu will pop up allowing you to merge them.

  Thanks! We're glad this was helpful.
  Thank you for your feedback.
  If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow

  Yes No

  Not Helpful 3 Helpful 5
• Question

  How do I allow changes to some cells of a protected sheet?

  

  Community Answer

  Select the whole worksheet by clicking the Select All button. On the Home tab, in the Font group, click the Format Cell Font dialog box launcher. On the Protection tab, clear the Locked box and then click OK.

  Thanks! We're glad this was helpful.
  Thank you for your feedback.
  If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow

  Yes No

  Not Helpful 3 Helpful 4

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Video

Tips

• If multiple users have access to your Excel document, lock all cells that contain important data or complex formulas to prevent the cells from being accidentally changed.
  Thanks

  Helpful 0 Not Helpful 0
• If the majority of cells in your Excel document contain valuable data or complex formulas, consider locking or protecting the entire document, then unlock the few cells that are allowed to be modified.
  Thanks

  Helpful 0 Not Helpful 0

Submit a Tip

All tip submissions are carefully reviewed before being published

Name

Please provide your name and last initial

Submit

Thanks for submitting a tip for review!

Advertisement