How to Fit a Spreadsheet to One PDF Page

To fit a spreadsheet on one PDF page, set the print area to the range you actually need, switch to landscape if the table is wide, and set the scaling so all columns fit on one page before converting. If the text then becomes too small to read, split the sheet into sections instead of shrinking it further.

A sheet can hold formatting or old values far outside the visible table, and Excel counts that empty space when it fits the sheet to a page. Select the range you want and choose Page Layout > Print Area > Set Print Area.

Press Ctrl+End to see where Excel thinks the sheet ends. If it lands far from your table, delete the unused rows and columns, not just their contents.

Landscape orientation gives a wide table noticeably more width on the same paper, and narrower margins add a little more. Both cost nothing in readability, so try them before scaling.

Then open Page Layout > Page Setup and, under Fit To, enter 1 page wide and leave the tall box empty. Every column fits across the page while long tables continue onto further pages. Use 1 page tall only for small tables.

Scaling shrinks everything by the same amount. As a rule of thumb, text under about 7 to 8 points is hard to read on paper and on a phone screen. A sheet using 11 point text at a 65% scale is already around 7 points.

When Excel reports a scale near or below that, change the approach instead of pushing the scale lower.

Split a very wide sheet into logical sections, such as a summary and a detail table, or hide the columns your reader does not need. If you let rows continue onto more pages, use Page Layout > Print Titles to repeat the header row on each page.

Open View > Page Break Preview to see where pages end and drag the blue lines if a page breaks in the wrong place.

After preparing the sheet, use Excel to PDF and inspect the left, right, top and bottom edges of every page. If something is still wrong, see the Excel to PDF troubleshooting checklist, or return to the Excel to PDF guide.