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.
Step 3: Choose the Print option at the bottom of the menu.
Step 4: Click the Headers & footers option at the bottom of the right column.
Step 5: Check the box to the left of Page numbers, then click the Print button.
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.
If you use Google Docs too and have ever needed to insert a new page in the middle of the document, then check out this guide.
- How to freeze a row in Google Sheets
- Where did the gridlines go in Google Sheets?
- How to change the date format in Google Sheets
- How to unhide a worksheet in Google Sheets
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.