Sunday, November 18, 2012

How to Unprotect Specific Areas in Excel


1. Launch Microsoft Excel 2010 and open the spreadsheet that's protected.
2. Click the 'Review' tab on the toolbar and click 'Unprotect Sheet' from the 'Changes' group. Enter the password if prompted.
3. Highlight the cell or cells that are to become unprotected.
4. Hold 'CTRL' and 'Shift' and press the letter 'F' on the keyboard and then release all of the keys to bring up the 'Format Cells' dialog box.
5. Click the 'Protection' tab and clear the check from the 'Locked' check box. Click 'OK' to save the changes. Repeat for additional cells or ranges as necessary.
6. Click the 'Review' tab and click 'Protect Sheet' under the 'Changes' group to protect the sheet.

Blogger news