How to Print Excel Columns Across the Same Page
Question details
The user wants to format a long list of data so that it prints in a multi-column layout, flowing from top to bottom and then continuing to the right on a single printed page.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Preparing a long, narrow worksheet (like a mailing list or inventory) for printing to save paper and improve readability.
- Observed behavior
- By default, Excel prints columns vertically down multiple pages or spills extra columns onto adjacent pages, lacking a native 'newspaper column' wrap feature.
Review your data list length and decide how many columns can comfortably fit on a single printed page without making the text too small. It is highly recommended to save a backup copy of your worksheet before rearranging the layout.
Manually Rearrange Columns for Side-by-Side Printing
Since Excel does not have a native 'newspaper column' feature, you can manually copy and paste your long list into adjacent columns to simulate a multi-column print layout.
This method involves cutting sections of your long list and pasting them to the right of your original data. While straightforward, keep in mind that the columns are not dynamically linked; if you add or remove data later, you will need to adjust the layout again.
Go to 'File' > 'Print' to preview how many rows fit on one printed page (e.g., 50 rows). Return to the worksheet.
Highlight the rows that exceed your first page limit (e.g., rows 51 to 100). Right-click and select 'Cut'.
Click the top cell of an empty column to the right of your original data (e.g., cell C1). Right-click and select 'Paste'. Repeat this process for the remaining data until all items are arranged side-by-side.
Highlight your newly arranged multi-column layout. Go to the 'Page Layout' tab, click 'Print Area', and select 'Set Print Area'.
Press 'Ctrl + P' to open Print Preview and verify that all adjacent columns now print neatly on the same page.

Use a Pre-designed Side-by-Side Workbook Template
Utilize a third-party macro-enabled workbook designed specifically to automate side-by-side printing.
Easily Format and Print Spreadsheets with WPS Office
WPS Spreadsheet provides intuitive Page Layout and Print Preview tools, making it incredibly simple to adjust your data into multi-column formats, scale to fit, and save paper while maintaining full compatibility with Microsoft Excel.
- 1. Open Your Document: Launch WPS Spreadsheet and open the file containing your long list of data.
- 2. Adjust Page Settings: Navigate to the 'Page Layout' tab to modify margins to 'Narrow' and maximize the printable area.
- 3. Arrange Your Data: Copy and paste your data into adjacent columns to create a side-by-side layout.
- 4. Preview and Print: Click on 'Print Preview' in the top menu to ensure all columns fit perfectly on one page, then hit print.

Frequently Asked Questions
Is there a native 'newspaper columns' feature in Excel?
No, Microsoft Excel does not have a built-in 'newspaper columns' feature for printing. You must manually rearrange the data into adjacent columns, use a macro, or use a word processor to achieve this specific layout.
Can I use Word to print Excel data in multiple columns automatically?
Yes. A highly effective workaround is to copy your long Excel list, paste it into a Word (or WPS Writer) document, and navigate to Layout > Columns to select a 2-column or 3-column layout. The word processor will automatically flow the text from the bottom of one column to the top of the next.
How do I make sure my newly arranged columns don't print on separate pages?
After arranging your columns side-by-side, go to the Page Layout tab and set your Print Area. Then, in the Print Preview screen, look for the 'Scaling' options and select 'Fit All Columns on One Page' to ensure nothing spills over to a second sheet.




