To unlock a sheet in an Excel workbook, right-click the sheet's tab and click Unprotect sheet. Enter the password, if prompted. Show
If you don't know the password, upload the sheet to your Google Drive, open it in Google Sheets, then re-download it to your computer. Did this summary help you?YesNo Thanks to all authors for creating a page that has been read 513,589 times. This article explains how to unprotect Excel workbooks. The information applies to Excel workbooks in Microsoft Excel 365, Microsoft Excel 2019, 2016, and 2013. How to Unlock an Excel Workbook as the OwnerMicrosoft Excel is packed with features. One such feature is the ability to protect your Excel files at the cell, spreadsheet, or workbook level. Sometimes it's necessary to unprotect Excel workbooks to ensure data changes apply correctly. This method assumes that as the owner of the file, you remember the password used to protect the spreadsheet.
How to Unprotect an Excel Workbook Without Knowing the PasswordYou may have protected your Excel workbook or spreadsheet and haven't had to modify it in some time, even years. Now that you need to make changes, you no longer remember the password you used to protect this spreadsheet. Fortunately, these steps will allow you to unprotect your workbook using a Virtual Basic script as a macro to identify the password.
FAQ
|