Google Sheets adds page numbers through its print settings rather than placing them in spreadsheet cells. The numbers appear on printed pages and PDFs.
Add page numbers in Google Sheets
- Open the spreadsheet.
- Choose File > Print.
- Expand Headers & footers.
- Check Page numbers.
- Review the preview, then select Next to print or save the sheet as a PDF.
You can also include the workbook title, sheet name, current date, or current time from the same section.
Change the page-number position
Choose Edit custom fields when you need more control over the header or footer. Insert the page-number field in the desired area, then check the preview. Scaling, margins, and repeated frozen rows can all affect the final number of printed pages.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.