How do you unlock cells in a protected Excel sheet?
To unlock cells in a protected Excel sheet, first unprotect the sheet by going to Review > Unprotect Sheet and entering the password if one was set. Then, select the locked cells you want to unlock, go to Format Cells > Protection, and uncheck the locked checkbox. Don’t forget to re-enable sheet protection after.
Why won’t my locked cells stay locked in Excel?
If you have locked cells that seem to allow editing even when protection is turned on, you likely have not activated sheet protection. After locking cells, go to the Review tab and select Protect Sheet. In the Protect Sheet dialog box, choose what editing you want to permit and enter a password if desired before clicking OK.
What do locking cells in Excel do?
Locking cells in Excel protects them from being edited when protection is turned on for a worksheet. This allows certain cells, like headers or formulas, to stay static while other cells can be edited by anyone accessing the spreadsheet.
How do you lock a specific cell in a formula?
To lock a single cell referenced in a formula, add a $ sign in front of the column and row references you want to remain constant. For example, to lock cell C2 as an absolute reference, you’d update the formula to reference it as $C$2. The $sign fixes that cell reference. As you copy or drag the formula cell, it will keep referencing exactly cell C2 instead of changing that reference.
Can locked cells still be formatted in a protected Excel sheet?
Yes, locked cells in a protected Excel sheet can still be formatted if the user has the formatting permissions when sheet protection is enabled. However, locked cells cannot be moved, deleted, or edited unless those permissions were also given before protecting the sheet.