How to Lock Specific Cells in Excel 2007


When you create a worksheet using Microsoft Office Excel 2007, you can protect the entire worksheet against changes or you can select specific cells to protect. This feature is handy when several people need to access the worksheet, but you don't want them to be able to change certain data fields. Once locked, you will not be able to enter or erase data from the cells until you unlock them. For additional security, you can require a password to remove protection from the cells.

  • Highlight the entire sheet by clicking the "Select All" button in the top-right corner of the sheet. It's just to the left of the A column and immediately above the 1 line.

  • Right-click anywhere on the sheet and select "Format Cells." The Format Cells pop-up window will open.

  • Click the "Protection" tap at the top of the window.

  • Click the block next to "Locked" to clear the check mark, and click "OK" to close the window.

  • Click anywhere on the sheet to remove the highlighting. Select all the cells you want to lock. You can drag to select cells that are connected. To select individual cells, you can press the "Ctrl" key as you click them one by one.

  • Right-click any of the highlighted cells, and select "Format Cells." Click the Protection tab and click the box next to "Locked" to check it. Click "OK" to exit the window.

  • Click the "Review" menu at the top of the window. Click the "Protect Sheet" icon on the right side of the menu options. Make sure the box next to "Protect worksheet and contents of locked cells" is checked. You can also enter a password so other users cannot unlock the cells. Click "OK" to finish.

Related Searches

  • Photo Credit Jupiterimages/Comstock/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!