Printing Problems

How to Print Excel Columns Across the Same Page

Chanuka GeekiyanageChanuka Geekiyanage Nov 2, 2026 871 views

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.

How to Print Excel Columns Across the Same 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.
Before you start

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.

Solution 1Recommended

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.

1
Determine Page Capacity

Go to 'File' > 'Print' to preview how many rows fit on one printed page (e.g., 50 rows). Return to the worksheet.

2
Select and Cut the Data

Highlight the rows that exceed your first page limit (e.g., rows 51 to 100). Right-click and select 'Cut'.

3
Paste into Adjacent Columns

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.

4
Set the Print Area

Highlight your newly arranged multi-column layout. Go to the 'Page Layout' tab, click 'Print Area', and select 'Set Print Area'.

5
Verify in Print Preview

Press 'Ctrl + P' to open Print Preview and verify that all adjacent columns now print neatly on the same page.

Manually Rearrange Columns for Side-by-Side Printing
Manual Updates Required: Because these columns are not technically linked, you must manually update the layout if the source data changes in the future.
Efficient Printing with WPS Office

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. 1. Open Your Document: Launch WPS Spreadsheet and open the file containing your long list of data.
  2. 2. Adjust Page Settings: Navigate to the 'Page Layout' tab to modify margins to 'Narrow' and maximize the printable area.
  3. 3. Arrange Your Data: Copy and paste your data into adjacent columns to create a side-by-side layout.
  4. 4. Preview and Print: Click on 'Print Preview' in the top menu to ensure all columns fit perfectly on one page, then hit print.
100% compatible with Microsoft Excel (.xlsx) file formatsIntuitive Print Preview to check column layouts instantlyAdvanced scaling options to fit more data onto a single printed pageLightweight, fast, and completely free to download
microsoft office alternative - wps office

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.