Headers in the Google Sheets print settings are where a page number goes when it has to sit at the top of each printed page. Turning on the page number option under Headers & footers is only half the job, because Google’s help page doesn’t say where that option places the number; if the preview shows it at the bottom, Edit custom fields lets you move it into a header box. Everything happens on a computer, in File > Print.
Where should the page number go?
Pick the row that matches what you need on paper or in the PDF.
| You want | Do this |
|---|---|
| A number at the top of every printed page | Turn on the page number under Headers & footers, then move it into a header box with Edit custom fields (steps below). |
| Any page number, position not important | Turn on the page number option and accept where the preview shows it. |
| Numbers on a printout made from the Sheets app on a phone | Set them up on a computer. Google’s app printing steps (More > Share & export > Print) mention no header or footer option. |
| Page numbers in a Google Doc, not a spreadsheet | Docs uses its own menu: see how to add Google Docs page numbers. |
Put the page number in the header
Google’s Print from Google Sheets help page gives the File > Print, Headers & footers and Edit custom fields labels used here.
- Open the spreadsheet in a browser on your computer and click File > Print.
- Choose what to print: Current sheet, Workbook or Selected cells. Printing every tab is covered in more depth in how to print an entire workbook in Google Sheets.
- Click Headers & footers and choose the information you want to include. Turn on the page number option there.
- Click Edit custom fields. The preview now shows header and footer boxes you can click into.

- If the number sits in a footer box, delete it there.
- Click a header box at the top of the page and add the page number from the options Sheets offers there.
- Click Confirm, then check the preview before you click Next.
Check the preview, then print or save
Scroll through at least the first two pages of the preview. Each page should show its own number in the header, and the footer should be empty unless you added something else there.
When you click Next, what happens depends on the browser. Google says that in Chrome you click Print in the next window, while Firefox and Safari download a PDF that you then print. The PDF keeps the header, so the numbers travel with a file you email.
If the layout is cramped, other print settings help before you print: switch to landscape with how to print a Google Sheets spreadsheet in landscape, or center a small table with how to print in the middle of the page in Google Sheets.
Settings that stay with the file
When Google introduced custom headers and footers in Sheets, its Workspace Updates announcement said print settings are saved, so they persist the next time you or a collaborator opens the same spreadsheet. That makes a header page number a one-time job for a report you print every month.
Two related options sit in the same Headers & footers area, according to Google: Repeat frozen rows and Repeat frozen columns. If row 1 holds your column titles and is frozen, repeating it puts those titles under the page number on every sheet of paper, so page 4 still makes sense on its own. Grid lines are a separate choice; see how to print with gridlines in Google Sheets.
When the number is missing or in the wrong spot
- The number is still at the bottom. The page number option was turned on, but it was never moved. Open Edit custom fields again, remove it from the footer box and add it to a header box.
- If a header box shows nothing after you click Confirm, reopen Edit custom fields, click the header box and add the page number again, then confirm.
- You can’t see numbers in the spreadsheet. Page numbers are part of the print settings, so they appear in the print preview and on the printed or PDF pages, not in the grid you edit.
- A phone printout has no numbers. Google’s Android and iPhone print steps don’t include headers or footers. Print from a computer, or save a PDF there and print that from the phone.
- The option isn’t where you expect. Make sure you opened File > Print in the spreadsheet itself. Sheets has no separate header menu outside the print settings in Google’s help.
Sheets page number answers
Can I print “Page 1 of 5” style numbers?
Google’s help page doesn’t list the fields that Edit custom fields offers, so it doesn’t promise a total-pages field. Click into a header box and look at the options shown there; if a page count is offered, place it next to the page number.
Can numbering start at a number other than 1?
Google’s Sheets print help describes no starting-number setting. If the pages join a longer report, number the combined document in the program you use to assemble it.
Will collaborators get my header too?
Yes, based on Google’s announcement that print settings persist when a collaborator opens the same spreadsheet. Anyone printing it later starts from your header, so tell them if you change it.
Is there an Insert menu for headers in Sheets?
Not in Google’s Sheets help, which keeps headers and footers in the print settings. The Insert route belongs to Google Docs, covered in the table above.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.