Fix Excel Print Area Splitting Columns Across Pages
Question details
Keep two Excel columns together on the same printed page when both are included in the print area.

- 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.
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.
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.
Select the cells in both columns, then choose Page Layout > Print Area > Set Print Area.
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.
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.

Reset manual page breaks in the worksheet
Use this if a manual page break is forcing the columns onto separate pages.
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. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Select the print area: Select the cells containing both columns, then choose Page Layout > Print Area > Set Print Area.
- 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. Preview and print: Choose File > Print and check that both columns appear together before selecting Print.

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.




