How to Lock Cells in Microsoft Excel

Microsoft Excel 2007
1. Open the Microsoft Excel 2007 application on your computer. Make sure you have the worksheet with the cells you want to lock open.
2. Select the cells that you want to lock on your worksheet using your mouse. You can also select an entire column or row.
3. Click on the “Home” tab and then click on the “Format” option from the “Cells” group. Click on the “Format Cells” option.
4. Click on the “Protection” tab and then click on the box next to the “Locked” field so that it’s selected. Click on the “OK” button.
5. Click on the “Review” tab and then click on the “Protect Sheet” option from the “Changes” group.
6. Enter a password for your worksheet in the “Password to unprotect sheet” field. Click on the “OK” button, and your cells will be locked.
Microsoft Excel 2003
7. Open the Microsoft Excel 2003 application on your computer. Make sure you have the worksheet with the cells you want to lock open.
8. Use your mouse to select all of the cells in the worksheet that you want locked. Make sure the cells are highlighted.
9. Click on the “Format” option from the top toolbar menu and then click on the “Cells” option.
10. Click on the “Protection” tab and then click on the box next to the “Locked” field so that it’s selected. Click on the “OK” button.
11. Click on the “Tools” option from the top toolbar menu and scroll over the “Protection” option. Click on the “Protect Sheet” option and then click on the “OK” button.