|Connect us with


How to Protect Excel Sheet?

Protect Excel | How to Protect | Unprotect Sheets

In Excel, you can protect Excel sheets with a password. if you protect Excel sheets nobody is able to edit or delete cells in a password protected sheet. if you have any important documents you can protect them with this option.

In this tutorial, we are going to discuss how to protect the Excel sheet from editing and how to protect an Excel sheet with the password with step by step examples.

Protect Sheet

To Protect Excel Sheet follow below steps,

1. Right click on the sheet you want to Protect.

2. Then click on Protect Sheet.

Protect Sheet in Excel

3. Provide a password to lock the sheet.

4. give options to users to allow actions to perform by clicking checkboxes.

5. if you don't check any boxes, the user can only able to view the sheet.

6. Confirm the password and click Ok.

Password Protected Sheet

7. Now your sheet is protected with a lock symbol.

Lock Symbol on Sheet

8. if any user clicks on the protected sheet it will give an alert.

Locked cell alert

In this way, you can easily protect sheets in Excel with password.

Unprotect Sheet

To Unprotect Excel sheet, Right click on the sheet you want to unlock.

Click on the Unprotect sheet option and enter the correct password.

Unprotect Excel Sheet

you can also Protect and Unprotect Excel sheets from Review Tab.

Protect and Unprotect sheet from Review Tab

Download sample sheet for practice and the password is "sa".

After watching the video you can download below sample sheet. and it helps you to do practice more. please subscribe for more videos on our youtube channel. if you like our tutorial please share it on Facebook and Youtube below.


To Get FREE Excel Shortcut Keys
       



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments



Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.