How to Unlock Excel spreadsheet in a protected Excel worksheet? How to lock and unlock specific cells and range of cells in a protected worksheet?
To unlock the Excel spreadsheet, follow these steps:
• Open the Excel file in which any spreadsheet is locked.
• Click on the Review option present in the Quick Access Toolbar.
• Under the Review option, click on Unprotect Sheet option.
• Enter the password and click on OK.
• Select the whole spreadsheet by clicking the Select All Button present at the top-left corner of the worksheet.
• Now, in the Protection tab, uncheck the ‘Locked’ check box and click on OK.
