How to Protect One Cell in an Excel Spreadsheet

Written by greg lindberg
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Protect One Cell in an Excel Spreadsheet
(BananaStock/BananaStock/Getty Images)

Microsoft Excel is a spreadsheet application that is a part of the Microsoft Office software package and allows users to store data, create graphs and cheats and calculate advanced equations. When using a spreadsheet document, you can lock a single cell or more to protect the data from being accidentally deleted. You can also protect the data by creating a password that only you know in order to unlock the cell. Protecting a single cell can be done the same way for both the 2003 and 2007 versions of Excel.

Skill level:

Other People Are Reading


  1. 1

    Open the Excel spreadsheet that contains that data and cells that you want to separately protect. Click on the individual cell that you want to lock.

  2. 2

    Click on the “Format” option from the top tool bar menu. Click on the “Cells” option and then click on the “Protections” tab.

  3. 3

    Click on the box next to the “Locked” field. Click on the “OK” button and you’ll be returned to the spreadsheet.

  4. 4

    Click on the “Tools” option from top tool bar menu. Scroll over the “Protection” option and then click on the “Protect Sheet” option.

  5. 5

    Type a password that will protect the cell from being unlocked by anyone else and then click on the “OK” button. The single cell in your spreadsheet will now be protected.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.