Janna Theme License is not validated, go to the theme options page to validate the license, you need a single license for each domain name.

Best Ways to Unprotect a Microsoft Excel Worksheet on Windows 10

Microsoft Excel is a popular tool used for data analysis and calculations. However, due to the nature of Excel, changes to a cell or worksheet can affect the resulting output. Therefore, most people use the Protect Sheet or Protect Workbook feature in Excel to prevent unwanted changes. If you need to unprotect a workbook or worksheet, we are here to provide you with the best ways to unprotect a Microsoft Excel workbook or worksheet on Windows 10.

unprotect-excel-worksheet-and-workbook-feature-image_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10

What happens when you need to unprotect an Excel worksheet or workbook? Of course, nothing will happen if you try these methods, and we'll show you how.

1. Unprotect Microsoft Excel with password

If you have the password for a protected Microsoft Excel worksheet, removing the protection is very easy. Here's how it works:

Step 1: Launch the Microsoft Excel file.

Unprotect Excel Worksheet and Workbook Step 1_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10

Step 2: To select a locked or protected worksheet, click any of the cells and you should get a dialog box indicating that the sheet is locked. Click OK to close the dialog box.

Unprotect Excel Worksheet and Workbook Step 2_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 3: In the protected worksheet, click Review on the Ribbon tab.

Unprotect Excel Worksheet and Workbook Step 3_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 4: In the Protection group, select Unprotect Worksheet.

Unprotect Excel Worksheet and Workbook Step 4_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10

Step 5: If you have a password for the worksheet, enter it in the pop-up dialog box and select OK. The worksheet will be unprotected if you enter the correct password.

Also read:  Best App Launcher for Windows 10

Unprotect Excel Worksheet and Workbook Step 5_4d470f76dc99e18ad75087b1b8410ea9 Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Note: You can only unprotect one worksheet at a time. If you have multiple protected worksheets, you must complete this process for each one.

Related articles

2. Unprotect Microsoft Excel without password

What if you don't have the password for a protected worksheet or workbook? You can still unprotect an Excel workbook or worksheet using VBA (Visual Basic for Applications) or another spreadsheet program like Google Sheets.

Unprotect Microsoft Excel by uploading to Google Sheets

This last method requires an internet connection and a Google account. Here's what you need to do:

Step 1: Visit Google Sheets on a web browser.

Visit Google Sheets

Unprotect Excel Worksheet and Workbook Step 6_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 2: In the New Spreadsheet title bar, click Blank (+).

Unprotect Excel Worksheet and Workbook Step 7_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 3: In the new spreadsheet, click File.

Unprotect Excel Worksheet and Workbook Step 8_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 4: Click Import from the menu.

Unprotect Excel Worksheet and Workbook Step 9_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 5: In the dialog box, click Upload and drag the Excel file from your device to Google Sheets.

Unprotect Excel Worksheet and Workbook Step 10_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 6: Once the file is finished uploading, select Import Data.

Also read:  How to Enable Narrator Caps Lock Alert in Windows 11

Unprotect Excel Worksheet and Workbook Step 11_4d470f76dc99e18ad75087b1b8410ea9 Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 7: Your Excel data should now be in Google Sheets. To convert it back to an Excel form, select File.

Unprotect Excel Worksheet and Workbook Step 12_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 8: Select Download and then Microsoft Excel (.xlsx). Once you run the downloaded file, the passcode restrictions should no longer be present.

Unprotect Excel Worksheet and Workbook Step 13_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Note: When you import Excel into Google Sheets or download Google Sheets in Excel format, your worksheets may undergo structural changes.

Unprotect Microsoft Excel using Microsoft Visual Basic for Applications (VBA)

You can easily unprotect a password-protected worksheet or workbook using VBA code. However, this method is only available for Microsoft Excel 2010 or earlier. Here's how it works:

Step 1: Create a copy of the Microsoft Excel file and start the copy.

Creating a copy ensures that you have a backup in case your VBA coding fails.

Step 2: Check the file extension of your workbook. If it has an .xlsx extension, you'll need to resave it in xls format by clicking File and then Save As.

The xlsx format is intended for workbooks created, edited, or saved in newer versions of Excel (Microsoft 2013 or later). The VBA method will not work for such workbooks.

Unprotect Excel Worksheet and Workbook Step 14_4d470f76dc99e18ad75087b1b8410ea9 Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 3: Enter a name for the Excel file, select .xls from the File Type drop-down list, and click Save.

Unprotect Excel Worksheet and Workbook Step 15_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 4: Launch the Visual Basic Editor by pressing Alt+F11 on your keyboard.

Unprotect Excel Worksheet and Workbook Step 16_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 5: On the Editor ribbon, select Insert and then Module from the menu list.

Also read:  How to Fix Microphone Sound Too Low on Windows 10

Unprotect Excel Worksheet and Workbook Step 17_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 6: A new VBA code window should open. Notice the two drop-down menus with General and Declarations.

Unprotect Excel Worksheet and Workbook Step 18_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 7: In the module window, copy and paste the code below:

Sub PasswordBreaker() Breaks worksheet password protection. Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer im i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 Activesheet. Chr(j) & Chr(k) & _ Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox "Password is " & Chr(i) & Chr(j) & _ Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _ Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub

Unprotect Excel Worksheet and Workbook Step 19_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 8: After pasting the code, change the second drop-down menu from Declarations to PasswordBreaker. Run the program by pressing F5 on your computer keyboard.

Unprotect Excel Worksheet and Workbook Step 20_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 9: You should see a new password in a pop-up window, featuring the letter A instead of your regular password. Once you click OK, the worksheet will be removed from the password-protected worksheet.

Unprotect Excel Worksheet and Workbook Step 21_935adec67b324b146ff212ec4c69054f Best Ways to Unprotect Microsoft Excel Worksheet on Windows 10 Step 10: Click Ctrl+S to save the changes.

Protect Google Sheets

These were the ways to unprotect a Microsoft Excel worksheet or workbook in Windows 10. Google Sheets also provides a way to restrict edits to cells and rows. You can do this by: Lock cells and rows in Google Sheets.

Tags
microsoft excel Windows 10 Best Ways to Unprotect a Microsoft Excel Worksheet on Windows 10 Ways to Unprotect a Microsoft Excel Worksheet on Windows 10
Go to top button