How To Unlock Excel Spreadsheet In Most Excellent Manner

Asked By 10 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #122606

How To Unlock Excel Spreadsheet In Most Excellent Manner

qa-featured

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.

Login/Register to Answer

Related Questions