'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Pivot Table Printing Everything on One Page
Question details
The user needs to prevent their pivot table from shrinking to fit onto a single printed page or PDF layout, ensuring the text remains at a readable size.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Printing a large pivot table or exporting it as a PDF document.
- Observed behavior
- The entire pivot table shrinks to fit onto a single page, completely overriding manual page breaks and making the exported text unreadably small.
Before modifying your print settings, ensure your pivot table is fully refreshed and all necessary rows or columns you wish to print are fully expanded.
Disable Scale to Fit in Print Settings
Turning off the single-page scaling option allows Excel to respect standard page breaks and print the pivot table at its normal, readable font size.
When 'Fit Sheet on One Page' is active, Excel forces all rows and columns to shrink regardless of manual page break settings. Disabling this resolves the microscopic text issue.
Click on 'File' in the top-left corner of Excel, then select 'Print' from the side menu to view the print preview.
Scroll to the very bottom of the Print settings pane where the scaling options are listed.
Click the dropdown menu that currently says 'Fit Sheet on One Page' or 'Custom Scaling' and select 'No Scaling'.
Check the print preview area on the right. You should now see the pivot table split across multiple pages with standard, readable text.
Adjust Scale Settings via Page Layout Tab
Use the Page Layout ribbon to precisely control width and height scaling, allowing columns to fit on one page while rows spread across multiple pages.
Print Pivot Tables Seamlessly with WPS Office
WPS Office Spreadsheet provides an intuitive Page Layout interface and robust Print Preview tools. It allows you to easily manage large pivot tables, adjust page breaks, and export highly readable PDFs without unexpected shrinking issues.
- 1. Open Your Pivot Table: Launch WPS Office Spreadsheet and open the Excel workbook containing your pivot table.
- 2. Access Page Layout: Click the 'Page Layout' tab on the top ribbon to view scaling and page break options.
- 3. Reset Scaling: Ensure both 'Width' and 'Height' are set to 'Automatic' to prevent the table from shrinking onto a single page.
- 4. Preview and Print: Go to Menu > Print to check the layout in Print Preview. Confirm the text is readable across multiple pages before printing or exporting to PDF.
Frequently Asked Questions
Why does my Excel pivot table text print so small?
This happens because the 'Fit Sheet on One Page' or 'Scale to Fit' option is enabled in your print settings. This forces Excel to shrink all rows and columns onto a single sheet of paper, heavily reducing the font size.
How do I force a pivot table to print on multiple pages?
To print on multiple pages, go to File > Print, scroll down to the scaling options at the bottom of the settings list, and select 'No Scaling'. Excel will then naturally divide the table across multiple pages based on your margin and paper size settings.
Does Scale to Fit ignore manual page breaks?
Yes. If 'Fit Sheet on One Page' is turned on, Excel ignores any manual page breaks you have set in order to compress the entire worksheet layout onto one page.
Can I fit columns to one page but let rows span multiple pages?
Yes. Go to the Page Layout tab. In the Scale to Fit group, set 'Width' to '1 page' and 'Height' to 'Automatic'. This keeps all your columns visible on a single page width while allowing the rows to continue onto the next pages at a readable size.
