To protect only certain cells in Excel, you unlock everything first, then re‑lock just the cells you want protected, and finally protect the sheet so those locked cells can’t be edited.

How to Protect Certain Cells in Excel

Step 1: Plan what should be editable

Before you click anything, decide:

  • Which cells should be locked (usually formulas, headers, totals).
  • Which cells should stay editable (usually input cells users fill in).

A simple trick: color your input cells (e.g., light green) and formula cells (e.g., light gray) so you know what to lock later.

Step 2: Unlock all cells first

By default, every cell in Excel is marked as “Locked,” but this doesn’t do anything until you protect the sheet.

  1. Press Ctrl + A to select the whole sheet.
  1. Right‑click anywhere in the selection and choose Format Cells.
  1. Go to the Protection tab.
  1. Uncheck Locked and click OK.

Now every cell is technically unlocked, even though nothing looks different yet.

Step 3: Lock only the cells you want to protect

Next, mark just the important cells as locked.

  1. Select the cells or ranges you want to protect (for example, your formula range A1:D10).
  1. For non‑adjacent cells, hold Ctrl while clicking each cell or range.
  1. Right‑click your selection and choose Format Cells.
  1. Go to the Protection tab again.
  1. Check Locked and click OK.

Those selected cells are now flagged as locked, but users can still edit them until you protect the sheet.

Step 4: Turn on Protect Sheet

Now you activate the actual protection:

  1. Go to the Review tab on the Ribbon.
  1. Click Protect Sheet.
  1. (Optional but recommended) Enter a password to prevent others from turning protection off, then confirm it when prompted.
  1. In the options list, choose what users are allowed to do (e.g., select locked cells, select unlocked cells, format cells, insert rows, etc.).
  1. Click OK.

Result:

  • Locked cells you marked earlier can’t be edited; Excel shows a warning if someone tries.
  • Any cells left unlocked remain editable for data entry.

Extra: Protect only formulas or special cells

If your main goal is to protect formulas but keep inputs open, Excel’s “Go To Special” helps.

  1. Select your data range.
  2. Press Ctrl + G → click Special….
  1. Choose Formulas and click OK (this selects only formula cells).
  1. With those cells selected, set them to Locked as in Step 3.
  1. Use Protect Sheet as in Step 4.

Now only formula cells are protected; input cells stay editable.

Mini forum‑style tips (like a Quick Scoop)

“I always start by unlocking the whole sheet, then only lock formula ranges and headers. Saves so much headache when sharing templates.”

“Color‑code inputs vs formulas before locking anything. It’s a visual guide for you and anyone using the file.”

A common modern use (especially in 2025–2026) is building “template” spreadsheets where only green input cells can be changed and all calculations stay untouched.

Simple HTML table recap (as requested)

[3][8][1] [9][6][1] [9][1] [4][8]
Goal What to do
Make only some cells read‑only Unlock all cells, lock the important ones, then use Protect Sheet.
Let users edit only inputs Leave input cells unlocked, lock formulas and headers, then protect the sheet.
Protect formulas only Use Go To Special → Formulas, lock those cells, then protect the sheet.
Fine‑tune what users can do In the Protect Sheet dialog, allow or deny actions like formatting, inserting rows, etc.
**TL;DR:**
  • Unlock everything, lock only the cells you care about, then protect the sheet with or without a password.
  • For templates, leave only user input cells unlocked and protect everything else so your formulas stay safe.

Information gathered from public forums or data available on the internet and portrayed here.