How To Unlock Cells In Excel Without Password
Lock All Cells | Lock Specific Cells | Lock Formula Cells
You can lock cells in Excel if you lot want to protect cells from being edited.
Lock All Cells
Past default, all cells are locked. However, locking cells has no consequence until you protect the worksheet.
1. Select all cells.
Advertisement
2. Correct click, so click Format Cells (or press CTRL + one).
3. On the Protection tab, yous can verify that all cells are locked by default.
4. Click OK or Cancel.
5. Protect the sheet.
All cells are locked now. To unprotect a worksheet, right click on the worksheet tab and click Unprotect Canvass. The password for the downloadable Excel file is "easy".
Lock Specific Cells
To lock specific cells in Excel, first unlock all cells. Next, lock specific cells. Finally, protect the sheet.
1. Select all cells.
ii. Right click, and then click Format Cells (or press CTRL + ane).
3. On the Protection tab, uncheck the Locked check box and click OK.
four. For example, select cell A1 and prison cell A2.
5. Right click, and and so click Format Cells (or press CTRL + 1).
half dozen. On the Protection tab, bank check the Locked cheque box and click OK.
Over again, locking cells has no effect until you protect the worksheet.
seven. Protect the sail.
Cell A1 and cell A2 are locked now. To edit these cells, you take to unprotect the sheet. The password for the downloadable Excel file is "piece of cake". You can nevertheless edit all other cells.
Lock Formula Cells
To lock all cells that contain formulas, first unlock all cells. Side by side, lock all formula cells. Finally, protect the sheet.
one. Select all cells.
2. Right click, and then click Format Cells (or press CTRL + ane).
three. On the Protection tab, uncheck the Locked check box and click OK.
4. On the Dwelling tab, in the Editing group, click Find & Select.
5. Click Get To Special.
6. Select Formulas and click OK.
Excel selects all formula cells.
7. Printing CTRL + 1.
8. On the Protection tab, check the Locked check box and click OK.
Notation: if you also check the Hidden bank check box, users cannot see the formula in the formula bar when they select cell A2, B2, C2 or D2.
Again, locking cells has no effect until you protect the worksheet.
9. Protect the sheet.
All formula cells are locked now. To edit these cells, yous have to unprotect the sheet. The password for the downloadable Excel file is "easy". You can still edit all other cells.
Advert
Source: https://www.excel-easy.com/examples/lock-cells.html
Posted by: kellumexclout.blogspot.com
0 Response to "How To Unlock Cells In Excel Without Password"
Post a Comment