How to unprotect excel sheet

Many people store essential, valuable, confidential, and official projects and data in Excel.

Due to the importance of Excel files, users can protect their data with a password.

But for any reason, you may not have access to the password, or you may have forgotten the password;

Do not worry! There are methods by which you can unlock Excel files.

How to protect excel spreadsheet with or without password

Most of the time, we want to share our Excel file with our colleagues and we want them to only view the file and not have the right to edit file.

In Excel, we can protect a cell or a part of the sheet or the entire sheet, or the entire workbook.

Step 1:

7 steps to make sure that no cell is locked.

First of all, we need to make sure that no cells are locked and Unlock any cells that needs to be editable.

1.open example.xlsx and select All Cells (CTRL+A).

2. Then press Right-Click of mouse.

3. Choose Format Cell.

4. In Format Cells Tab.

5. Select Protection Tab.

6. Make sure No option is Marked.

7. Then Select OK.

These 7 steps should always be done at the beginning of everything to make sure that no cell is locked.

How to protect a special cell in excel with or without password

For example, we want the header of a table in Excel to be locked.

1.Open example.xlsx and select A1:E1.

2. Then press Right-Click of mouse.

3. Choose Format Cell.

4. In Format Cells Tab.

5. Select Protection Tab.

6. Make sure both options is Marked.

Locking cells or hiding formulas has no effect until you protect the worksheet.

7. Then Select OK.

8. Select protect Sheet in Review Tab.

9. In protect Sheet Tab.

10. Mark Any Features You Want to Be protected.

11. Then Select Ok.

If you double-click on any of the cells A1:E1, you will see the following message.

How to protect a rang of cells in excel with or without password

  1. Open example.xlsx and select A1:E10.

2. Choose Review Tab.

3. Click on Allow Edit Ranges.

Review Tab excel

4. In Allow Users To Edit Ranges Tab.

5. Select Modify.

 Allow Users To Edit Ranges Tab excel

6. In Modify Range Tab.

7. Choose title for your Area.

8. Choose Cells That You want to Protect.

9. Then Select Ok.

Modify Range Tab excel

10. In Allow Users To Edit Ranges.

11. Select protect Sheet.

Select protect Sheet excel

12. To protect Sheet Tab.

13. Set Your password to Protect Or Unprotect Sheet.

14. Mark Any Features You Want to Be protected.

How to unprotect excel sheet

How to Protect excel sheet with or without password

  1. Choose Review Tab.

2. click on Protect Sheet.

Review Tab excel

3. In protect Sheet Tab.

4. Mark Any Features You Want to Be protected.

5. Then Select Ok.

how to Protect excel sheet with or without password(excel 2019)

How to Unprotect excel sheet with or without password

  1. Choose Review Tab.

2. click on Unprotect Sheet.

how to  Unprotect excel sheet with or without password

How to Protect excel sheet with the password with macro and VBA code

Sub protectcellswithpassword()

    Range("A1:E10").Select
    ActiveSheet.Protection.AllowEditRanges.Add Title:="student", Range:=Range( _"A1:E10"), Password:="123"
    ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
        False, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
        AllowFormattingRows:=True, AllowInsertingColumns:=True, AllowInsertingRows _
        :=True, AllowInsertingHyperlinks:=True, AllowDeletingColumns:=True, _
        AllowDeletingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
        AllowUsingPivotTables:=True
End Sub

How to Protect excel WorkBook With or Without the password

  1. Choose Review Tab

2. click on Protect WorkBook

3. In protect Structure and Windows tab

4. Then Select Ok

how to Protect excel WorkBook With or Without password

Leave a Reply

Your email address will not be published. Required fields are marked *