Sunday, December 23, 2012

How to Protect One Cell in an Excel Spreadsheet


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. Click on the “Format” option from the top tool bar menu. Click on the “Cells” option and then click on the “Protections” tab.
3. Click on the box next to the “Locked” field. Click on the “OK” button and you’ll be returned to the spreadsheet.
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. 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.

Blogger news