Category: protection/security
Hi there,
Let us celebrate this week by "Protecting YOUR ....."
> Protecting Excel Cells
> Protecting Excel Worksheet
> Protecting Excel WorkBook
> Protecting Excel Worksheet Based on User
> Protecting Excel Window
> Protecting Excel Structure
In this post, you can learn how to protect excel cells from the unknown user.
PROTECTING EXCEL CELLS:
Protecting Excel Cells is as simple as switching on the light in your reading room.
The reason why I am saying this because, this is also as simple as GoTo REVIEW ribbon and click on "Protect Sheet" option in Changes Group.You will receive a "protect sheet" dialogue box, click on OK.
That's it. Now, try to edit in any of the cells, You will not be able to edit any of the cells.
Let me tell you an important point here. By default, all the cells in the Excel workbook is locked. So, when you click on protect sheet and hit enter with out updating the password, (excel by default takes the password as "blank", and protects all the cells.
Recent comments