Click Here to Drop Your Doubts
Summary: In this class, Jaywant Sir will be explaining how to do protection functions.
Process: Worksheet level protection: To protect your worksheet click on the review tab, go to protect section, click protect sheet, in protect sheet dialogue box, set password, select the options as per required, click okay, re-confirm your password, click okay. Your sheet is now protected.
To un-protect, the sheet click on the review tab, go to protect section, click on unprotect sheet.
Prevent unwanted changes to the data in the sheet by specifying what information can be changed.
Conclusion: After completion of this class you will be able to do Worksheet level protection