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
- Open example.xlsx and select A1:E10.
2. Choose Review Tab.
3. Click on Allow Edit Ranges.
4. In Allow Users To Edit Ranges Tab.
5. Select Modify.
6. In Modify Range Tab.
7. Choose title for your Area.
8. Choose Cells That You want to Protect.
9. Then Select Ok.
10. In Allow Users To Edit Ranges.
11. Select protect Sheet.
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 Protect excel sheet with or without password
- Choose Review Tab.
2. click on Protect Sheet.
3. In protect Sheet Tab.
4. Mark Any Features You Want to Be protected.
5. Then Select Ok.
How to Unprotect excel sheet with or without password
- Choose Review Tab.
2. click on Unprotect Sheet.
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
- Choose Review Tab
2. click on Protect WorkBook
3. In protect Structure and Windows tab
4. Then Select Ok
