For a long table, I would usually fit the columns to one page wide while allowing several pages vertically. Fitting the whole worksheet to one page can make it unreadable. Set the print area, paper and repeated headings before judging the printer’s output.
On this page
Our recommendation
I favour one-page-wide output for long tables, with a sensible print area and repeated headings. If the text remains too small, split the report logically or use a larger supported format rather than forcing an unreadable page.
Choose the correct scaling goal
Microsoft documents a one-page Width with Automatic Height option in desktop Excel, allowing rows to continue on later pages. It also warns that fitting everything to a single page can reduce readability. Check the current controls for the platform you use rather than assuming the web and desktop interfaces are identical.
Remove irrelevant columns from the print area, select the intended orientation and check the actual loaded paper size. A smaller print area can solve the width problem without a severe scale reduction. Keep any excluded information available in the source workbook.
Proof every page
Inspect the first, middle and final pages, including repeated headings and page numbers where needed. Check that a total or note has not landed alone on an extra page. Compare the smallest text with the distance at which the print will be read, not only the on-screen preview.
If you use Fit to scaling, note that Excel can ignore manual page breaks. Choose whether controlled page boundaries or an automatic width fit matters more for the job, then use the relevant supported settings. Keep the PDF proof and worksheet settings together when handing the file to another person.
A twelve-column report
A report has twelve columns and 300 rows. Instead of selecting one page wide by one page tall, exclude two internal-use columns, choose landscape and fit one page wide with height automatic. Review the resulting several-page proof. The right result is a readable complete table, not the lowest possible page count.
Before you act
- Set the print area and loaded paper size.
- Allow vertical pages when the report is long.
- Inspect the final page and repeated headings.
Use the Paper size converter to apply the guide to your own setup.
Keep exploring
- Actual size or Fit? Choose PDF print scaling by the job
- US Letter, Legal and A4: dimensions and print setup
Sources and research notes
Research checked on 21 October 2026. Product specifications are manufacturer statements; examples and buying judgements are our analysis. No hands-on product test is implied.
Build on what you just learned
Your next useful step.
Proof the page, binding edge and reading order.
A filled PDF prints blank fields: check the saved file and print layers
Save and reopen the filled PDF, then inspect the print preview and the viewer’s form/comment options.
Read the guide →Duplex printing: automatic, manual and binding-edge differences
Automatic duplex prints both sides without asking you to reload the sheet. Manual duplex requires a documented reinsertion step. Neither feature tells you whether…
Read the guide →