How to
protect Excel worksheet? Do you know it? Well, if you share your worksheets with others, you may need it.
This is to avoid the worksheet being change by others, while they still can view or print it. You also can lock certain areas in the worksheet so you do not inadvertently make changes.
By default, when you lock a worksheet, Excel locks every cell in the worksheet, and the formulas are visible to anyone who uses the worksheet.
You can specify the cells that remain unlocked, and you can hide formulas.
The following steps will guide you on how to lock cells and protect the worksheet with password.