How to Lock Cells in Excel: F4, Freeze Panes & Protection

How do I lock specific cells in Excel?

Locking specific cells in Excel requires two steps: formatting the cells as locked, then enabling sheet protection. By default, all cells carry the Locked attribute — so you’ll need to reverse that for any cells you want users to edit.

Select and format cells

Highlight the cells you want to protect, then right-click and choose Format Cells. Navigate to the Protection tab and verify that the Locked checkbox is checked. This step marks the cells as protected, but the lock won’t activate until you turn on sheet protection.

• Select cells: click and drag across the range
• Right-click > Format Cells (or press Ctrl+1 on Windows)
• Go to Protection tab > check Locked
• Click OK

Protect the worksheet

Once your cells are formatted, head to the Review tab and click Protect Sheet. You can set an optional password — without one, anyone can disable the protection. After you click OK, the locked cells become read-only while any unlocked cells remain editable.

How do I lock cells in Excel using F4?

The F4 key is Excel’s shortcut for absolute referencing — it locks cell references in formulas so they don’t shift when you drag or copy the formula. This works in the formula bar while you’re editing, and it cycles through four reference styles.

Absolute referencing with F4

Click on a cell reference in your formula (like A1), then press F4. The reference toggles to $A$1, which locks both the row and column. This is useful when you want a formula to always point to a fixed value or cell.

Toggle $ signs

F4 cycles through four states with repeated presses: $A$1 (fully locked), A$1 (row locked), $A1 (column locked), and back to A1 (relative, no lock). Each press advances to the next state.

• First press of F4: $A$1 — both row and column fixed
• Second press: A$1 — row fixed, column moves
• Third press: $A1 — column fixed, row moves
• Fourth press: A1 — back to relative reference

How do I lock rows and columns in Excel?

Freeze Panes keeps specific rows and columns visible while you scroll through large spreadsheets — this isn’t the same as locking cells for editing, but it prevents you from losing your headers or labels off-screen.

Freeze top row or first column

The quickest options: go to the View tab and choose either Freeze Top Row or Freeze First Column. A thicker border appears below the frozen row or to the right of the frozen column, confirming the freeze is active.

• Click View tab > Freeze Top Row
• Or: View tab > Freeze First Column
• The frozen area shows a darker border once active

Freeze panes

For more control, select a cell (like B2 to freeze row 1 and column A together), then click Freeze Panes. Everything above and to the left of that cell stays locked in place as you scroll. To unfreeze, click Unfreeze Panes in the same menu.

• Select the cell below and right of your freeze area
• Click View tab > Freeze Panes
• Windows shortcut: Alt+W+F+F for both, Alt+W+F+R for top row, Alt+W+F+C for first column
• Unfreeze: Alt+W+F+U

The implication: Freeze Panes and cell locking serve different purposes — Freeze Panes keeps headers visible during scrolling, while sheet protection prevents unauthorized edits.

How to make only certain cells editable in Excel?

If you want most of your spreadsheet locked but a few cells open for input (like a data-entry form), Excel makes this possible by selectively unlocking cells before you protect the sheet.

Unlock editable cells first

Select the cells you want users to edit, then right-click and choose Format Cells. On the Protection tab, uncheck the Locked checkbox. Leave all other cells with Locked checked — or leave them as-is, since all cells are locked by default.

Protect sheet allowing edits

Go to Review > Protect Sheet. When the dialog opens, you can fine-tune what users can do: uncheck “Select locked cells” to prevent navigation to locked areas, or keep it checked so users can view but not modify those cells.

• Select form input cells
• Format Cells > Protection > uncheck Locked
• Review > Protect Sheet
• Optionally uncheck “Select locked cells” to restrict movement too

Can I lock cells without protecting a sheet?

The short answer: no, not for editing protection. The Locked attribute only takes effect when sheet protection is active. However, the F4 shortcut gives you formula reference locking without any protection — useful for keeping formulas stable as you copy them across rows.

Formula absolute refs only

The F4 key works independently of sheet protection. When you’re writing a formula and press F4, it adds dollar signs to lock references. This prevents the formula from adjusting when dragged or copied. This works regardless of whether Protect Sheet is enabled.

• F4 adds $ signs to lock cell references in formulas
• No sheet protection required for this type of locking
• Useful for filling formulas down or across without shifting fixed references

Advanced VBA methods

For more control, VBA macros can lock cells programmatically based on conditions, but this still requires protecting the sheet at some point. Without sheet protection, any VBA-locked cells remain editable by anyone who opens the VBA editor.

“By default, all cells have the Locked formatting unless you previously turned it off.”

— Microsoft Support (Official Documentation)

“Freezing panes to lock columns and rows in Excel is a simple way to ensure that specific cells remain obvious while you scroll.”

— Indeed Career Advice (Career Guide)

Related reading: F4 shortcut, freeze panes and protect sheet in Excel · Excel formulas for finance like points to miles transfers

Beyond protecting specific cells with sheet locks, many users also freeze Excels first row to keep column headers visible while scrolling through large spreadsheets.

Frequently asked questions

For spreadsheet users sharing files with colleagues, the decision is straightforward: lock the cells that matter and protect the sheet, or risk having formulas overwritten. Use F4 for formula stability when building complex sheets, and reserve sheet protection for anything that goes outside your team.