How to Lock Cells in Excel for Mac

To lock cells in Excel for Mac, select the cells, open Format Cells and check Locked on the Protection tab, then choose Review > Protect Sheet. A cell’s Locked setting does not take effect until you protect the worksheet. Excel marks all cells as locked by default, so if some cells should remain editable, unlock those first and then protect the sheet.

This helps prevent accidental changes to formulas, labels, or other important entries while still allowing people to work in designated input cells. Sheet protection is an editing safeguard, not a way to encrypt a workbook or keep a determined person from accessing its contents.

What You’ll Need

Excel for Mac and the workbook you want to change. The steps below apply to current Microsoft 365 versions; button placement can vary slightly between releases.
Permission to change the worksheet’s protection settings. If the sheet is already protected, you will need to unprotect it first, and a password may be required.
Optional: a password for sheet protection. You can protect a sheet without one, but anyone with access may then be able to remove protection easily.

Step-by-Step

Open the worksheet and decide what should be editable. Identify the cells you want to protect, such as formula cells in a totals column, and any cells users should still be able to change, such as blank entry fields. If the whole sheet should be read-only, you can skip the unlocking step below. Save a copy of the workbook first if you are making a substantial change to an important file.
Unprotect the sheet if necessary. Go to the Review tab and look for Unprotect Sheet. Choose it and enter the password if Excel asks. In some Mac versions, protection commands are also available from Tools > Protection. If the sheet is not protected, continue to the next step. You cannot change cell locking settings on a protected sheet until you unprotect it.
Unlock cells that people should be allowed to edit. Select the editable range. To select the whole worksheet, click the small triangle at the intersection of the row numbers and column letters; this avoids selecting only the current data region. Open Format Cells with Command+1, or use Home > Format > Format Cells. On the Protection tab, clear the Locked checkbox and click OK. If you only need to unlock a few cells, select those cells instead of the entire sheet.
Select the cells you want to lock. Click a cell or drag across a range. To select separate ranges, hold Command while selecting each range. For a whole column or row, click its letter or number heading. If the cells you want to protect are the only cells left locked, you can leave the default settings in place; otherwise select each protected range and set its Locked option explicitly.
Set the selected cells to Locked. Open Format Cells again with Command+1, choose the Protection tab, check Locked, and click OK. The setting applies to the selected cells, but it still does not prevent editing by itself. If Locked appears dimmed or unavailable, check whether the worksheet is currently protected and unprotect it before trying again.
Protect the worksheet. On the Review tab, select Protect Sheet. If you do not see the command there, look under Tools > Protection > Protect Sheet. In the dialog, choose whether to set a password and review the permissions listed, such as selecting locked or unlocked cells. Leave only the actions users need enabled, then confirm the protection. If you enter a password, Excel may ask you to type it again.
Check the result. Try to change a locked cell; Excel should block the edit or display a protection message. Then test an unlocked input cell; it should remain editable. If either result is wrong, unprotect the sheet and revisit the cell settings and permissions. Save the workbook after confirming that the protection behaves as intended.

Common Mistakes

Setting Locked but not protecting the sheet. Locked is a cell property, not an active barrier by itself. Until you use Protect Sheet, users can still edit cells marked Locked.
Forgetting that all cells start out locked. This surprises people who protect a sheet without first unlocking the intended input areas. The result is that the entire sheet may become difficult to edit. Unlock the permitted ranges before turning on protection.
Unlocking the wrong range. A selection can include neighboring formula cells, especially when selecting a broad block. Check the selected range in the Name Box or select individual columns or cells carefully before changing the Protection setting.
Confusing sheet protection with workbook protection. Protect Sheet controls editing on one worksheet. Protect Workbook concerns workbook structure, such as adding, deleting, or moving sheets. Protecting the workbook structure does not automatically lock individual cells.
Assuming a password is a recovery guarantee. Excel does not provide a simple way to retrieve a forgotten sheet-protection password. Keep it somewhere secure and accessible to the people responsible for maintaining the workbook.

Tips

Make input cells easy to recognize. Give editable cells a fill color or border and add a short instruction such as Enter a date here. Formatting is only a visual cue; the Locked setting and sheet protection control whether a cell can be edited.
Allow only the actions users need. The Protect Sheet dialog lists permissions that can include selecting locked or unlocked cells and using certain worksheet features. For a simple form, allowing selection of unlocked cells may be enough. If users need to sort or filter, test those actions after protection because the required permissions depend on the sheet setup.
Protect formulas deliberately. You can lock formula cells while leaving input cells unlocked, so users can change assumptions without overwriting calculations. Consider hiding formulas through the Protection tab only if you also protect the sheet; the Hidden setting does not conceal a formula on its own.
Keep a clean, editable master. Before sharing a protected workbook, save a separate copy that is not protected or keep a safe record of the password. This makes future changes easier if the person who set up protection is unavailable.
Remember that protection is limited. Sheet protection is useful for preventing ordinary accidental edits, but it is not a security boundary for confidential data. Do not rely on it to keep sensitive information secret.

Troubleshooting

I can still edit a cell that I marked Locked. The most common cause is that Protect Sheet was not turned on afterward. Open Review and check whether the command says Unprotect Sheet; if it does, protection is active. If it still says Protect Sheet, activate protection and test again. Also verify that you changed the Locked setting for the exact cell you are editing.

I cannot edit cells that are supposed to be open. Unprotect the sheet, select the intended input cells, and open Format Cells > Protection. Clear Locked and click OK, then protect the sheet again. Confirm that the range was selected correctly; a merged cell or an adjacent selection can make it less obvious which cells were changed. Check the Protect Sheet permissions too, since the option to select unlocked cells may have been disabled.

The Protection tab or controls are unavailable. The worksheet may still be protected, or the workbook may be in a state that prevents editing. Choose Review > Unprotect Sheet and supply the password if prompted. If you do not know the password, ask the workbook owner or locate an authorized unprotected copy; Excel does not offer a normal password-reset control for protected sheets.

I cannot find Protect Sheet on the ribbon. Make sure you are looking at the worksheet, not a chart sheet, and check the Review tab. Depending on the Excel for Mac release and ribbon layout, the command may be under Tools > Protection > Protect Sheet. If the ribbon is minimized, expand it or use Excel’s command search if it is available in your version.

Protection blocks sorting or filtering. Unprotect the worksheet, set up the required filter or sort range, and protect it again with the relevant action allowed in the Protect Sheet dialog. Excel may restrict some operations on protected ranges, so test with a representative user workflow. If the needed operation remains unavailable, consider whether users can perform it before protection or whether a different workbook design is more suitable.

Frequently Asked Questions

Can I lock just one cell in Excel for Mac?
Yes. Select that cell, set Locked on the Protection tab in Format Cells, and protect the worksheet. Other cells will also retain their current Locked settings, so unlock them first if they should remain editable.

Why does Excel say all cells are locked?
Locked is the default setting for cells, but it has no effect while the sheet is unprotected. To allow edits after protecting the sheet, clear Locked for the cells users should be able to change.

Can I lock cells without a password?
Yes. Protect Sheet can be used without setting a password. Protection will still discourage accidental changes, but someone with access to the sheet may be able to remove it more easily.

How do I remove cell locking later?
Choose Review > Unprotect Sheet, entering the password if requested. Then select the cells, open Format Cells > Protection, clear Locked, and click OK. You can leave the sheet unprotected or protect it again with revised settings.

Does locking a cell hide its formula?
No. Locking prevents edits after sheet protection is enabled; it does not hide the formula. If you need to hide a formula from the formula bar, set Hidden on the Protection tab as well and then protect the worksheet.

Can people still copy data from a protected sheet?
Often they can. Sheet protection mainly limits worksheet changes, and permissions vary with the options selected. Do not use it to protect confidential data from someone who can open the workbook.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.