In this article:

How to Add Page Numbers in Google Sheets (2024 Update)

May 8, 2024

Google Sheets Page Numbers

Google Sheets does not inherently support page numbers within the spreadsheet while you're working in the online interface. However, when you prepare to print a Google Sheets document or save it to PDF, you can access print settings that allow you to include page numbers.

How to Add Page Numbers in Google Sheets

Follow the process below to insert page numbers in Google Sheets. 

1. Go to File Menu and Select 'Print' to Access Print Settings

In your spreadsheet, click on "File" in the menu bar, then select "Print" from the dropdown menu. This will open the Print settings in a new window or tab.

how to add page numbers in google sheets

2. Scroll to 'Headers & Footers' in Print Settings

In the Print settings, find the "Headers & footers" section. You might need to scroll down or search under a different tab. Check the box next to "Page numbers" to add them to your document.

google sheets page numbers

3. Preview Document to Ensure Correct Page Number Placement

Use the preview pane in the Print settings window to check how the page numbers appear. Make any necessary adjustments to the page number settings.

how to insert page numbers in google sheets

4. Print Your Document or Save It as a PDF

If you're satisfied with the preview, you can print your document directly from the Print settings window. Click "Next".

add page numbers to google sheets

Then, select "Print".

google sheets add page numbers

Alternatively, you can save it as a PDF by choosing "Save as PDF" in the destination options.

We hope that you now have a better understanding of how to add page numbers in Google Sheets. If you enjoyed this article, you might also like our article on Google Sheets VSTACK or our article on how to increase border thickness in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->