Joe B.

Expert ★★★★★ 27,853 satisfied customers

Specialities: Google Sheets, Excel, reporting dashboards, print layout, data cleanup & automation

Fix missing header rows in Google Sheets — freeze top row & repeat headers when printing

Technician

Hey! We’ll sort out why your Google Sheets header row is missing or not sticking at the top.
A couple of quick questions so I can target the fix: Did the header row disappear visually from the sheet, or is it only missing when you scroll or print/export to PDF? Have you used filters, sorting, hiding rows, or View → Freeze recently? And are you printing from Chrome, another browser, or downloading to PDF first?

Customer

The first row used to be my column headers. Now when I scroll, it just disappears with the rest of the data. On printouts, each page has no header row at the top, so it’s just numbers and I can’t see which column is which. I’m working in Google Sheets in Chrome on a laptop.

Technician

Got it. This is a mix of two common issues:
1) The header row isn’t frozen, so when you scroll down, it behaves like normal data and “goes missing” from view.
2) The sheet isn’t set to repeat the header row on every printed page, so your printouts don’t show column names at the top.
The good news: we can recreate or re-identify the header row, freeze the top row so it always stays visible, and then enable Repeat frozen rows so the header appears on every page you print.

Customer

That makes sense. I might have changed something when I was cleaning the sheet. How do I tell Google Sheets which row is the header and freeze it again so it stays on screen?

Technician

Step 1 — Recreate and freeze the header row in Google Sheets
1) First, confirm which row should be your header row — usually row 1 with labels like Date, Name, Amount.
2) Click the row number on the left (e.g. 1) to select the entire row.
3) Go to View → Freeze → 1 row. This “pins” that header row so it stays visible when you scroll down the sheet.
4) If your header is actually in row 2 or 3, select that row instead and choose View → Freeze → Up to current row. Now the frozen top rows act as your header band.
Once frozen, your Google Sheets header row won’t vanish as you scroll.

Customer

I froze row 1 and it’s pinned now, which is good. But when I go to print preview, the first page still doesn’t show the header, and the second page definitely doesn’t repeat it. How do I repeat the header row on every printed page?

Technician

Step 2 — Turn on “Repeat frozen rows” when printing
Google Sheets can repeat the header row on every printed page, but you need to toggle it:
• In your sheet, make sure the header row is frozen (which you already did).
• Click File → Print to open the print preview window.
• On the right side, expand “Headers & footers”.
• Under Row & column headers, make sure “Repeat frozen rows” is checked.
Now every page in the print preview should show your frozen header row at the top, even if your data spans multiple pages.

Customer

Okay, that works for the current sheet. But in another sheet, the header row literally looks gone. Row 1 is empty, and my column names seem to have shifted down. Maybe I deleted it by accident or filtered it out. Can I restore a missing header row somehow?

Technician

Step 3 — Recover a missing or deleted header row
Let’s check a few things that often make the header row appear to be missing:
• Look for a tiny arrow between row numbers (for example between 1 and 2). If you see it, right-click the arrow and choose “Unhide row”. Your header may just be hidden.
• Check if a filter is active: if the funnel icon is green in the toolbar, click it and clear filters. Sometimes the header row gets mistakenly included in a filtered range and looks gone.
• If the header was really deleted, use Edit → Version history to open an older version of the sheet. You can copy the original header row labels and paste them back into row 1, then freeze that row again.
Once your header labels are restored and frozen, we can re-enable the print settings.

Customer

Got it. I unhid row 1 and the labels are back. One more thing: I sometimes need two header rows, like a main heading and a subheading row. Can Google Sheets freeze and repeat more than one header row?

Technician

Yes — you can have multiple header rows in Google Sheets.
• Select the row number just below the last header row (for example, click row 3 if rows 1–2 are headers).
• Go to View → Freeze → Up to current row (3). That freezes both header rows at the top.
• When you print, the Repeat frozen rows option will repeat all frozen header rows on every page, giving you stacked headers for complex reports.
This is handy for big tables where you want category headers plus column labels visible while you scroll and when you print.

Customer

Nice. I also share these sheets with my team. Sometimes someone changes the freeze settings or prints without headers and we get inconsistent reports. Any way to lock this down or at least make it harder to break?

Technician

Good call. A few ways to protect the header rows in shared Google Sheets:
• Use Data → Protect sheets and ranges to protect the header row or header range so only editors you choose can change it.
• Add a short note in row 1 or a nearby cell like “Do not delete — header row is frozen & used for printing”.
• For important dashboards, create a separate read-only “Report” sheet that pulls from your raw data using =FILTER or =QUERY. Set the freeze & print settings on that report sheet and give view access to most users.
This keeps your Google Sheets header configuration consistent and reduces accidental changes.

Customer

That should help. Before we wrap up, can you walk me through a quick checklist so I remember what to check when header rows go missing or don’t print correctly?

Technician

Absolutely — here’s your quick checklist for Google Sheets missing header rows:
• Make sure the header row is visible (no hidden rows, no filters hiding row 1).
• Confirm the correct row(s) are frozen using View → Freeze so headers stay at the top when you scroll.
• In File → Print → Headers & footers, make sure Repeat frozen rows is turned on so headers repeat on every printed page.
• Print a test page or PDF preview to verify the header looks right.
If you ever get stuck again, you can screenshot your print preview and open the chat — we’ll walk through your exact sheet together.

Customer

Perfect. I can see the header row again, it stays frozen while I scroll, and it repeats on every printed page. That’s exactly what I needed, thanks!

Technician

Summary: To fix Google Sheets missing header rows, first recover or rebuild the header labels, then freeze the top row(s) via View → Freeze so they stay visible, and finally turn on “Repeat frozen rows” under File → Print → Headers & footers so your header repeats on every page. This keeps your reports readable on screen and on paper. Need help applying this to a complex sheet? Open the chat.

Quick answer: the accepted fix

Accepted fix when Google Sheets header rows go missing or don’t print: unhide row 1, restore your column labels, and freeze the header row with View → Freeze. Then in File → Print → Headers & footers, check Repeat frozen rows so the header appears on every page. Print a quick test to confirm that the header row stays visible and repeats properly.

FAQ

Step-by-step: fix missing header rows in Google Sheets

1. Check row 1 for your column labels. Unhide rows or restore labels from version history if needed.
2. Select the header row and go to View → Freeze (choose 1 row or Up to current row) so the header stays visible while you scroll.
3. Open File → Print, then expand Headers & footers and enable Repeat frozen rows to repeat your header row on every printed page.
4. Review the print preview and print a test page. If something looks off, adjust which rows are frozen and the print range, then try again.

Note for different browsers (Windows/macOS)

1. On both Windows and macOS, the freeze header and repeat frozen rows options live inside Google Sheets itself, not the browser. Use the same steps in Chrome, Edge, or Safari.
2. If your printer dialog still removes headers, double-check that the print range includes the frozen header row and that your browser or system print settings aren’t overriding the Google Sheets preview.

Sources

• Google Docs Editors Help — Freeze or unfreeze rows & columns in Google Sheets
• Google Docs Editors Help — Print from Google Sheets (repeat frozen rows)
• The Bricks — How to print the top row on each page in Google Sheets

Matt ● replies in < 1 min

Technician Expert

⭐⭐⭐⭐⭐ Trusted by 27,000+ customers

Alex · Expert's Assistant

Start Chat

5 Tech Support Specialists are online right now.