How to Protect One Cell in an Excel Spreadsheet

Updated February 21, 2017

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.

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.

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

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

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

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.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author