Microsoft Excel contains features that allow you to set a password and specify precisely which workbook elements should be protected by that password. If you periodically enter large amounts of data into an Excel worksheet for analysis then you may want those data entry cells to be locked after entry is complete. The procedure for doing so is slightly counter-intuitive; by default Excel protects all cells in a protected worksheet, so to protect only certain data entry cells you must tell Excel which cells you don't want to lock when you password protect the worksheet. Then when data entry is complete you can lock the secured cells with a password.
- Skill level:
Other People Are Reading
Run Microsoft Excel and open the spreadsheet that contains the cells you wish to protect.
Highlight all cells that you do not want to have locked with a password after data entry is complete.
Click the "Home" tab, then click "Format" in the "Cells" group.
Click "Format Cells" in the drop down list to display cell formatting options.
Click the "Protection" tab, then uncheck the box next to the "Locked" heading. Click "OK" to save your changes and exit from the dialogue box.
Enter your data into the worksheet.
Click the "Review" tab, then click the "Protect Sheet" button.
Type a password in to the "Password to unprotect sheet" box, if desired. Click OK to lock all cells in your worksheet that you didn't choose to unlock.
- 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