Protecting Cells

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Protecting Cells

Instead or protecting a whole workbook or a whole worksheet, you can just choose what cells to exclude from editing. Once again, you have many options.

When protecting cells, you can choose to lock some of them so their values cannot change. In reality, the cells that you don't want anybody to change must be unlocked. By default, when you start a worksheet, Microsoft Excel unlocks all cells so that you can write values in them. To check this, in the Cells section of the Home tab of the Ribbon, click Format and you would notice that the Lock Cell item is checked:

Lock Cell

You can also display the Format Cells dialog box and click its Protection tab:

Protection

To unlock the cells, you can click Format -> Lock Cell to remove the check box. if you are using the Format Cells dialog box, uncheck the Locked check box in the Protection tab.

When protecting a worksheet, you can choose the options in the Protect Sheet dialog box. To display it, in the Cells section of the Home tab of the Ribbon, click Format and click Protect Sheet.

Practical LearningPractical Learning: Protecting Cells

  1. From the resources that accompany these lessons, open the CPAR1 workbook
  2. In the lower part of the interface, click the Repair Invoice tab sheet
  3. Click Cells D4:E5
  4. Press and hold the Ctrl key down
  5. Click the following cells:
    1. D8:J9
    2. D10:E10
    3. G10:H10
    4. J10
    5. D12:E13
    6. G12:J13
    7. B16:I21
    8. B24:J29
    9. J33
  6. Release Ctrl
     
    College Park Auto Repair
  7. On the Ribbon, click Home if necessary.
    In the Cells section of the Ribbon, click Format and click Format Cells...
  8. Click the Protection tab
  9. Click the check box of Lock to remove its check mark
     
    Protection
  10. Click OK
  11. In the Cells section of the Ribbon, click Format and click Protect Sheet...
  12. In the text box, type P@ssw0rd1
     
  13. Click OK
  14. In the Confirm Password dialog box, type P@ssw0rd1
     
    Confirm Password
  15. Click OK
  16. Click Invoice # and type Receive
  17. Notice that you receive a message box. Read it and click OK
  18. Click the cell under Job Performed
  19. Type Changed the brakes
  20. Press Tab
  21. Type 65.95 and press Tab
  22. Notice that the next cell under the Job Performed receives focus

Unprotecting Cells

Since you protect cells using the worksheet, to unprotect them, you use the description we saw for the worksheet. After unprotecting the worksheet, re-lock it.