How to Freeze Rows in Google Sheets: A Step‑by‑Step Guide

What Are Frozen Rows and Why Use Them?

In Google Sheets a frozen row (sometimes called a locked or pinned row) stays visible at the top of the screen while you scroll through the rest of the worksheet. The data isn’t protected from editing; it simply remains in view, acting like a static header.

Why Freeze Rows?

1. Keep headers in sight – When a sheet contains dozens or hundreds of rows, column headings can disappear off‑screen. Freezing the header row ensures you always know what each column represents, reducing mistakes.
2. Maintain context for grouped data – A frozen row with a date or category label lets you see the context for each group as you scroll.
3. Simplify navigation – You don’t have to scroll back to the top to check a label, saving time.
4. Help collaborators stay oriented – Everyone sees the same reference point, which lowers the chance of misinterpretation.
5. Support filters and data validation – Keeping headers visible makes filtering and validating data more intuitive.

In short, frozen rows are a visual aid, not a security feature. They help you work faster, avoid errors, and keep the most important information front and center, especially in large or shared spreadsheets.

Freezing the First Row

Freezing the top row keeps your column headings visible while you scroll through long lists.

Steps

1. Open the sheet you want to edit.
2. Select any cell in the first row (you don’t need to highlight the whole row).
3. Use the View menu
4. Click View → Freeze → 1 row.
5. The first row turns gray‑shaded and stays at the top when you scroll.
6. Verify by scrolling down; the header row should remain visible.

Shortcut (optional)

• Hover over the thin gray line between rows 1 and 2 until the cursor becomes a double‑arrow.
• Click and drag the line down to row 1 (to freeze) or back up (to unfreeze).

Quick reference

Freezing Multiple Rows

You can freeze any contiguous block of rows that starts at the top of the sheet.

Steps

1. Select the row below the block you want frozen – e.g., click row 5 to freeze rows 1‑4.
2. Open the Freeze menu – View → Freeze.
3. Choose Up to current row (5) (the number reflects the row you selected).
4. Verify – a gray line appears beneath the frozen rows; they stay visible while you scroll.

Quick reference

Tips & Gotchas

• Contiguous only – You can’t freeze non‑adjacent rows; split the data onto separate sheets or use a script if you need that behavior.
• Keyboard shortcut – Alt + W, F, U (Windows) or ⌥ + W, F, U (Mac) opens the Freeze submenu quickly.
• Cross‑platform – Freezing works in the web app, mobile app, and offline mode. In Excel the equivalent is View → Freeze Panes → Freeze Top Row (or Freeze Panes after selecting a cell beneath the rows you want to lock).

Unfreezing Rows and Adjusting the Freeze

Unfreeze All Rows

1. View → Freeze → No rows (or No columns if you also have a column freeze).
2. The gray frozen area disappears and the sheet scrolls normally.

Reduce the Freeze Range

If you have frozen more rows than needed, simply choose a smaller preset:

Drag‑Handle Method

The gray bar below the frozen rows (or to the right of frozen columns) can be dragged:

• Reduce – drag the bar upward until it sits above the last row you want frozen.
• Increase – drag it downward to include additional rows.

Changes apply instantly, so you can see exactly which rows are locked.

Consistency Tips

• Use a single header row across all sheets to avoid constant re‑freezing.
• Document the intended freeze layout in a hidden “Instructions” tab for collaborators.
• Remember that freeze settings are sheet‑specific; changing one tab does not affect the others.

Common Issues and Troubleshooting

Troubleshooting flow

1. Check permissions – Ensure you have edit access.
2. Verify view mode – Exit any filter or protected view.
3. Refresh the browser – A quick reload often restores a missing freeze bar.
4. Re‑apply the freeze – Select the desired rows and choose View → Freeze again.
5. Test in a new sheet – If it works there, the problem is specific to the original sheet (e.g., a script or add‑on).

When to use a script

If you need the same freeze range on many sheets, an Apps Script can apply it automatically:

function freezeTopRows() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  ss.getSheets().forEach(sheet => sheet.setFrozenRows(3)); // freezes rows 1‑3 on every sheet
}

Run the script once, and all sheets will have rows 1‑3 frozen.

FAQ

How do I freeze more than one row in Google Sheets?

Select the row below the block you want frozen, then choose View → Freeze → Up to current row (X), where X is the row number you selected. Google Sheets will lock all rows above that selection (e.g., selecting row 6 freezes rows 1‑5).

Can I freeze rows in a Google Sheets add‑on?

Yes. Many add‑ons expose a “Freeze rows” command, but they ultimately call the same sheet.setFrozenRows() method that the native menu uses. The result is identical; just ensure the add‑on has edit permission for the spreadsheet.

What happens to frozen rows when I share the sheet?

Frozen rows are a view setting, not a data setting, so every collaborator sees the same frozen rows as long as they have edit access. View‑only users can see the freeze but cannot change it. If you change the freeze setting, the update is saved to the file and instantly visible to anyone who opens the sheet.

All steps work in the current web version of Google Sheets and in the mobile app. No additional software or extensions are required.