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.
Follow the process below to insert page numbers in Google Sheets.
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.
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.
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.
If you're satisfied with the preview, you can print your document directly from the Print settings window. Click "Next".
Then, select "Print".
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.