Office Dễ Hiểu

How to print Excel on A4 without cutting off columns

Fit all columns to one page wide while allowing rows to continue onto more pages.

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

Page LayoutScale to Fit

Before

Columns A:K are split across two pages horizontally.

After

Width = 1 page puts A:K on one page width.

Check the result

In File → Print, check column K and the smallest text.

Step-by-step instructions

  1. Select the required table and set Page Layout → Print Area → Set Print Area when needed.
  2. Choose Page Layout → Size → A4. Use Landscape if the table is wide.
  3. Under Scale to Fit, set Width to 1 page and Height to Automatic.
  4. 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