lock cells in a worksheet in Ms Office Excel

Simple Tricks For lock cells in a worksheet

How To lock cells in a worksheet





Simple Tricks For lock cells in a worksheet

How to lock cells in a worksheet in excel Follow these steps to lock cells in a worksheet

Follow these steps to lock cells in a worksheet

1. Select the cells you want to unlock.

2. Click Home tab

3. in the Alignment group, click Format Cells popup

4. Click Protection tab

5. de-select the Locked check box

6. click OK to close the popup

7. Click Review tab

8. Click select either Protect Sheet or Protect Workbook,

9. de-select -- Select Locked Cells

10. Give Your Password For Cancel Production - ok

11. Type Retype Password - ok