Thursday, February 14, 2013

How to Lock Specific Cells in Excel 2007


1. 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.
2. Right-click anywhere on the sheet and select 'Format Cells.' The Format Cells pop-up window will open.
3. Click the 'Protection' tap at the top of the window.
4. Click the block next to 'Locked' to clear the check mark, and click 'OK' to close the window.
5. 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.
6. 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.
7. 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.

Blogger news