Sometimes we need to protect our
Excel files from other users in our organisation which will allow them to view
only, and there are also other cases where some of the users need to edit the
certain cells or columns by restricting other cells which are containing
complex formulas, and also sometimes we need to keep the confidentiality of
formulas from other users by hiding the formulas in the cells.
Step-1
How to protect the sheet from
other users using formula.
Step-2
How to unprotect the specific
areas in excel file from other users by unchecking the protection from the
format cells options.
Step-3
How to hide the formulas in the specific
areas in the excel file by checking the hidden option in the format cells.
Step-4
After the above steps protect the
sheets with the password and now we can able to edit the area which we allowed
and also we can’t able to view the formulas in the cells.
Course Details
Video Link: Watch Video