This article explains why the footer on each page of your exported Excel file shows “Pg. 1 of 1” and what it looks like when printed.
Why This Happens
Each sheet in the exported Excel file is its own page, so when viewed individually it correctly displays “Pg. 1 of 1.” This is how Excel handles footers per sheet and is not a bug with the export.
When You Print
When you print the entire workbook, Excel recalculates the page numbers across all sheets. The footer will update to reflect the correct page count — for example, “Pg. 2 of 7.”
To see the correct pagination before printing:
- In Excel, go to File > Print.
- Set the print option to Print Entire Workbook.
- Page numbers in the footer will reflect the full document correctly.
Related Articles
- Why Changes Aren’t Showing Up in My Tech Pack