Excel: Protecting Worksheets

Excel allows you to protect worksheets so that users cannot make changes. You can also set it so that data in particular cells can be changed whilst others remain locked. This could be useful if you want users to enter information but not change the formulas, functions or text.

It is possible to protect worksheets with a password or without. If you do use a password make sure you do not forget it.

Here is a video tutorial to show you how to do this.

One thought on “Excel: Protecting Worksheets”

Comments are closed.

Making Technology Easy to Understand