If you share spreadsheets with colleagues, clients, vendors, or students, locking cells prevents accidental edits. It does not make the workbook impossible to break, but it does stop the most common problem: someone typing over a formula or deleting a reference cell.
Quick Answer: How to Lock Cells in Excel
- Select the cells users should be allowed to edit.
- Press Ctrl + 1, go to Protection, and uncheck Locked.
- Select formula cells and confirm Locked is checked.
- Go to Review →Protect Sheet.
- Choose allowed actions and click OK.
1. Understand Excel locking first
In Excel, every cell is technically locked by default. That setting does nothing until you protect the worksheet. This is the part that confuses most users: locking cells and protecting the sheet are two separate steps.
2. Unlock the cells people should edit
Select the input cells, press Ctrl+1, open the Protection tab, and clear Locked. These are usually assumptions, dates, quantities, prices, dropdown selections, or notes that users need to change.
3. Keep formula cells locked
Leave formula cells locked so users cannot overwrite calculations accidentally. This is especially important in budgets, invoices, forecasts, pricing sheets, dashboards, and shared templates.
4. Protect the worksheet
Go to Review →Protect Sheet. Choose whether users can select locked cells, select unlocked cells, format cells, sort, filter, or use pivot tables. Add a password only if you need basic control, not security-grade encryption.
5. Test the workbook like a real user
After protecting the sheet, try editing an input cell, changing a formula cell, using filters, and entering data in expected places. If something useful is blocked, adjust the protection settings before sharing.
How to Lock Only Formula Cells
The cleanest protection method is to leave formulas locked and unlock only input cells. Use Home → Find & Select → Go To Special → Formulas to select formulas quickly. Then open Format Cells and confirm those cells remain locked. Next select input cells manually or by color and unlock them. Finally protect the sheet.
Should You Use a Password?
A sheet protection password is useful for preventing casual edits, but it is not the same as strong file encryption. Use it to guide users, not to protect highly sensitive data. If the workbook contains private financial, HR, or customer information, also control file access through OneDrive, SharePoint, Google Drive, or your document management system.
Common Mistakes
- Locking cells but not protecting the sheet: the lock setting has no effect until sheet protection is turned on.
- Protecting every cell: users cannot enter valid inputs, so they copy the sheet or ask for an unlocked version.
- Blocking filters: if users need to filter rows, allow filtering in the Protect Sheet options.
- Not auditing first: protect the sheet only after checking formulas, hidden sheets, and broken references.
Before You Send a Locked Workbook
Protection is most useful after the workbook is already clean. Run a quick audit for formula errors, inconsistent formulas, hidden sheets, and external links. A protected spreadsheet with broken formulas is still broken; it is just harder for users to fix.