PrOtEcT sHeEt AnD wOrKbOoK

How to protect our sheet or workbook?

If we want that nobody can make changes in our sheet than we need to protect our sheet. And we can easily do this by clicking on REVIEW tab.

Sometimes it became very important to protect our sheet because the data inside is really important for us or the organization in which we work. At that time we don’t want to take any risk so we need to protect it. But if we want nobody can see our data also what is written we need to protect our whole workbook. Now in this we learn how to protect our sheet and workbook both. And also if we want some cells to work.

Protect sheet

To protect our sheet we have to follow the below steps:

• In excel click on review tab.
• There you see option protect sheet. You have to click on that option.

• Now they ask for a password to unprotect that sheet then you have to re-enter that password. And then click ok.

If anyone tries to write on this he/she will be unable to write anything. Only you can work on the sheet after entering the password.

Protect workbook

Workbook is protected so that nobody can check the matter written inside the sheet. It was the protection of the whole book. Which can seen only by you. The following steps are given below.

• For protecting workbook you have to click on review tab.
• After that click on protect workbook as you can see in the above picture the icon near protect sheet.
• Then enter and re-enter the password and click ok.

How to unlock some cells?

Apart from protecting sheet and workbook there is an another thing unlocking cells. By this we can unlock some cells from the protected sheet. Like if we want to fill a form. For this you have to check below the following steps:

We have made a small data related to the person detail.

Now select all the cells in which you want the person to fill the details. You can select the cells by CTRL+LEFT click of mouse.

Now right click on the mouse you will see various options click format. After clicking format you see a screen like below.

Now click on protection and un tick the locked button. Then press ok.

After that protect the whole sheet by applying the above steps. Now the person can’t make any changes he/she will only fill the blanks which you unlock.

This are some simple things by which you can safe /protect your data for others. And make your work easier.