Category: protection/security

Protect YOUR ...... (1 of 6 series)


Hi there,

Let us celebrate this week by "Protecting YOUR ....." 

Lock Cell Option in Excel Protect Sheet

> 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 Cells in Excel By Locking 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.

Full story »

Contact / Help. ©2020 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.