How to Add Page Numbers in Google Sheets

Much of what you do in a Google Sheets spreadsheet concerns the way that the spreadsheet looks on a screen.

If you are editing a spreadsheet or sharing it with someone, then it’s likely that they are going to be viewing it on their phone or their computer.

But many spreadsheet users will print their spreadsheets because they find it to be a more effective way to absorb the information.

While there are some basic steps to take to ensure that a spreadsheet prints well, such as using gridlines and fitting rows or columns to a page, another aspect that can improve printed readability is the inclusion of page numbers.

Our guide below will show you how to add page numbers in Google Sheets so that users who print your sheet will be able to tell what page they are on more easily.

How to Insert Page Numbers in a Google Spreadsheet

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop Web browsers as well.

Step 1: Open your Google Drive and open the spreadsheet that you wish to edit.

Step 2: Select the File tab at the top-left of the window.

click the File tab

Step 3: Choose the Print option at the bottom of the menu.

choose Print at the bottom of the menu

Step 4: Click the Headers & footers option at the bottom of the right column.

select the Headers and footers tab

Step 5: Check the box to the left of Page numbers, then click the Print button.

how to add page numbers in Google Sheets

You can also access the Print menu by pressing the Ctrl + P keyboard shortcut.

Note that Google Sheets only allows you to put page numbers at the bottom-right of the page.

Additional reading