How to Unlock Cells in Excel
Note: In order to unlock the cells, sheet protection must first be turned off first, then only you will be able to unlock the cells.
Step 1: Select the cell which you want to lock.
Step 2: Under Home, click on the arrow-downlock option under the alignment section.
Step 3: Click on the Protection tab and deselect the lockare .
Step 4: Then click on OK. Now cells are unlocked.
How to Protect Sheet in Excel
Protect Sheet in Excel with Password- Quick Steps
Step 1: Right Click on the Worksheet Tab
Step 2: Select Protect Sheet
Step 3: Enter Password
Step 4: Select the Actions you want to allow the Users
Step 5: Click Ok
When sharing an Excel file with others, it’s often important to protect a worksheet to prevent unauthorized changes. In this article, you’ll learn how to protect a sheet with a password in Excel, as well as how to unprotect it when needed.