Class 55: Data Protection Part 2 Copy

Click Here to Drop Your Doubts

Summary: In this class, Jaywant Sir will be explaining how to do protection functions.

Process: Partial Protection: Select the target data, right-click select format cell, in format cell dialogue box click protection, un-tick locked option, click okay, click on the review tab, go to protect section, click protect sheet, in protect sheet dialogue box, enter a password, select the options as per required, click okay, re-confirm your password, click okay. Your sheet is now partially protected.

To un-protect, the sheet click on the review tab, go to protect section, click on unprotect sheet, enter the password, and click okay.

Conclusion: After completion of this class you will be able to do Partial Worksheet Protection.