Choose A4 paper and set Width to 1 page in Page Layout → Scale to Fit. Leave Height on Automatic to avoid squeezing a long table onto one page.
Visual walkthrough
Before
Columns A:K are split across two pages horizontally.
After
Width = 1 page puts A:K on one page width.
In File → Print, check column K and the smallest text.
Step-by-step instructions
- Select the required table and set Page Layout → Print Area → Set Print Area when needed.
- Choose Page Layout → Size → A4. Use Landscape if the table is wide.
- Under Scale to Fit, set Width to 1 page and Height to Automatic.
- Open File → Print. Confirm that the final column is visible and that the text is readable. Adjust margins or reduce the number of columns if necessary.
Frequently asked questions
Why does the table still use several pages?
Width controls horizontal pages. With Height on Automatic, a long table continues vertically onto additional pages.
Reference: Microsoft Support