How To Unlock Excel Spreadsheet In Most Excellent Manner

Asked By Goatham Chan 10 points N/A Posted on - 07/05/2016

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?

• Status: Open
• Question Views: 620
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By slashgroup 0 points N/A #122606

How To Unlock Excel Spreadsheet In Most Excellent Manner

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.

About slashgroup

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/05/2016
• Question Category: MS Excel