12-16 Lab WU Protected Cells

12-16 Lab WU Protected Cells- Where Not to Type

The excel worksheets in 12-16 Lab WU are protected and some of the cells are locked, which means you can't type in the locked cells while you can type in the unlocked cells. The cells are locked because you should not type in them; they contain formulas that make the calculations work. The unlocked cells should or can be typed in to add grades, to change heading names, to change grade weights, and to set up 12-16 Lab WU with your class information. If you unprotect the worksheets, then the formulas in the locked cells will no longer be protected from accidental deletion. I recommend that you keep the worksheets protected. If the worksheets are protected, then the cells with formulas are protected.

Worksheets 1-12 - Where Not to Type

The screen shot of a worksheet from 12-16 Lab WU below shows the cells where no typing is needed. These are the cells that are locked when the worksheet is protected and they are not supposed to be typed in. These cells receive information from other parts of 12-16 Lab WU.

The image below shows the areas that are safe to type. Do not type in the darkly shaded areas of the image. NOTE: these areas are not darkly shaded in the actual workbook; they are locked if the worksheet is protected.

Click to see the full sized version.

Protect, Unprotect 

If a worksheet needs to be unprotected, follow the steps below

Images based on Microsoft Excel 2002

To Unprotect a Worksheet, from the toolbar at the top of Microsoft Excel look for:
Tools > Protection > Unprotect Sheet
Note: Leaving a worksheet unprotected is not recommended.

To Protect the Worksheet: from the toolbar at the top of Microsoft Excel look for:
Tools > Protection > Protect Sheet