» Protecting Cells in the Sheet in Excel 2007
CATEGORY - Excel Editing
VERSION - Microsoft Excel 2007
Protecting cells in the sheet means that the contents of cells cannot be changed and/or formulas can be hidden from view.To protect cells in the sheet:
Step 1: Locking the cells:
1. Press Ctrl+1 and select the Protection tab in the Format Cells dialog box.
2. Select the Locked checkbox and click OK.
Step 2: Protect a sheet:
Select Review - Protect Sheet (in Changes Group)
Or
1. Select the sheet tab, right click and select Protect Sheet.
2. Enter a password and click OK.
Book Store:
Recommended Books:
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Windows XP Pocket Reference
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
No comments have been submitted.
