Format Cells C X Number Alignment Font Border Fill Protection Locked Hidden Locking cells or hiding formulas has no effect until you protect the worksheet (Review tab, Changes group, Protect Sheet button). OK CancelProtect Sheet ? X Protect worksheet and contents of locked cells Password to unprotect sheet: Allow all users of this worksheet to: Select locked cells Select unlocked cells Format cells Format columns E Format rows Insert columns Insert rows Insert hyperlinks Delete columns Delete rows OK Cancel1 2 3 Baltic Leave - Microsoft Excel O X Home Insert Page Layout Formulas Data Review View Developer N M R W L to Cut Arial - 10 AA Normal Bad E AutoSum Wrap Text General Good Ep Copy Fill 41 4 Paste Merge & Center * % " 68 08 Conditional Format Neutral Calculation Check Cell Insert Delete Format Sort & Find & Format Painter Formatting * as Table 2 Clear Filter * Select Clipboard Font Alignment Number Styles Cells Editing B2 A B C D E F G H C K L 1 Husband Wife 2 Salary 3 Age 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 14 4 Documentation Leave Data Leave Summary Q11 Advanced Filter Protection Validation +1. Using a blank workbook 2. Make sure there is a blank worksheet in the workbook. Rename the worksheet to Data. 3. Save the workbook as Module & Supplement. 4. In the Data Worksheet: a. Enter the word Salary in A2 b. Enter the word Age in A3 Enter the word Husband in Cell 81 d. Enter the word Wife in Cell CI Put a fill color in the cells 82:03. To set Data Validation 1. Click on the Data Tab. Ject Cells 83:03 `on Data Validation. Settings 6 Allow: Whole Number Data: between Min: 25 Max: 90 Under Error Alert: a. Style: Stop b. Title: Age requirements C. Error Message: You have entered an imalid age. To Protect Cells from being changed 1. Select celis B2:03 2. Right dick on cells, select format cells, then select the Protection tab 3. Deselect the box next to Locked. Click on OK. 4. Click on the Review Tab , select Protect Sheet 5. Make sure the Protect worksheet and contents of locked cells box is checked. . Also select the Select locked cells and Select unlocked cells boxes b. Note: do not enter a password, c. Dick OK. 6. Now test putting data in a locked cell 7. Enter any salaries. B. Enter valid ages Now change a valid age to an Invalid age