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
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for