Printing Problems

Fix Excel Print Area Splitting Columns Across Pages

Amos GikundaAmos Gikunda Nov 18, 2026 868 views

Question details

Keep two Excel columns together on the same printed page when both are included in the print area.

Fix Excel Print Area Splitting Columns Across Pages
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet has a selected print area containing two columns that need to print side by side.
Observed behavior
Print preview places the two columns on separate pages even though both are included in the print area.
Before you start

Open the affected worksheet and check File > Print to see where the columns split. Confirm that the intended cells are included in Page Layout > Print Area.

Solution 1Recommended

Fit the Excel print area to one page wide

Use scaling to keep both columns on the same page horizontally, or reduce their widths if the result is too small.

1
Set the print area

Select the cells in both columns, then choose Page Layout > Print Area > Set Print Area.

2
Adjust the scaling

On the Page Layout tab, find Scale to Fit and set Width to 1 Page. Leave Height set to Automatic if the sheet may need multiple pages vertically.

3
Check the preview

Open File > Print and confirm that both columns appear side by side. If the text is too small, return to the sheet and drag the column header boundaries to reduce the column widths.

Fit the Excel print area to one page wide
Scaling affects print size: Fitting a wide print area to one page can shrink text. Adjust column widths or page orientation if the preview is difficult to read.
Print worksheets with WPS Office

Keep spreadsheet columns together in WPS Office

Open your workbook in WPS Spreadsheets, set the print area, and adjust page scaling to fit the columns together on the printed page.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Select the print area: Select the cells containing both columns, then choose Page Layout > Print Area > Set Print Area.
  3. 3. Set the page width: Open Page Setup from the Page Layout tab and adjust the scaling to fit the sheet to one page wide.
  4. 4. Preview and print: Choose File > Print and check that both columns appear together before selecting Print.
Fit selected spreadsheet columns on one page wideOpen and edit Microsoft Excel XLSX and XLS filesPreview the layout before printingUse a familiar spreadsheet interface for page setup
microsoft office alternative - wps office

Frequently Asked Questions

Why do columns in the same print area print on separate pages?

The print area determines which cells are included, but it does not guarantee they fit on one page. Column widths, paper size, margins, scaling, or a page break can split them.

How do I fit all columns on one page without fitting all rows?

In Excel, go to Page Layout > Scale to Fit, set Width to 1 Page, and leave Height set to Automatic. The rows can then continue onto additional pages.

Will resetting page breaks change my print area?

No. Page Layout > Breaks > Reset All Page Breaks removes manual page breaks from the active worksheet; it does not clear the selected print area.

What can I do if fitting the columns makes the text too small?

Reduce the column widths by dragging their header boundaries, or try Page Layout > Orientation > Landscape. Check File > Print again to see whether the text is readable.