Protect Your Data

Here I'm going to learn you how you can protect your data by unexpected / unauthorized editing. Go to this Link & download example file. (This file contains all the data for my previous lessons. This lesson can follow you without downloading the file)

Open any Microsoft Excel file.

Go to review tab and Changes sub group

Click on Protect Sheet option

Then select the options you need to do after the file is protected.

Set password and Click on Ok

Try to enter or delete any data.

You can realize that it is not allowed by Excel. If you want to unprotect the sheet using the "unprotect sheet" command.

If you need to enter or update data regularly unprotecting and protecting the sheet in regular intervals may be not suitable.

Then follow below steps.

Unprotect sheet if you have already protected it.

Click on Allow Users to edit ranges command on same sub group.

Click on "New" and select the range or cell you want to enter data.

Name it in the title field.

If you want to protect this cell / range also using a password, enter the password into the "Range Password' field. (If you entered a password you have to enter it to unlock your cell to be updated)

You can enter many ranges as you wish.

After adding the fields, click on apply and close the pop up window.

Then protect the sheet using previous steps.

Now try to edit ranges you assigned.