How to print a single column across a page?

Hi Femi,

Thank you for your reply, and I was able to adjust the page order. But I do not have anything referring to "Multiple Pages" on the Margins tab of the Page setup dialog box. Is there another way to change the number of columns that will be printed per page?

Thanks,

Emma

Hi Karen.

There is no quick and easy way to wrap multiple columns in a spreadsheet like you are wanting. I did some searching and found that there are some ways with some complicated formulas or macros. However, if I understand correctly, you are only concerned with printing this data, not re-arranging it in your spreadsheet. Given that, here is a YouTube video that describes an easy way to accomplish what you are wanting to do.

How to Print Long Columns in Excel on 1 Page - Snake Columns / Newspaper Columns (youtube.com)

This is not a Microsoft site so use appropriate care and caution as with all internet sites.

Hi Emma. I am an Excel user like you. There is a formula that will convert your column into multiple columns. You can place this on the same sheet and then set the print area or enter it on a new sheet to print from there.

Use this formula for your example data:

=WRAPCOLS(A1:A8,2)

.

.

To use on your entire column of data enter the correct range in the formula and then how many rows you want in each column so that they will all print on the page as you have it laid out.

I have 2 columns of data and I want to print both columns next to each other and two sets of columns on a page. I have 318 lines of data, so it takes 8 pages to print out, would like to reduce just a couple with two columns per page and front to back printing.

Here is what I want to be able to print:

Column A Column B Column A Column B

1A 1B 5A 5B

2A 2B 6A 6B

3A 3B 7A 7B

4A 4B 8A 8B

When I try you formula, I get all of column A repeated, then when it is finished it moves to column B.

Thank you for your help.

Hi Emma D, I'm Femi and I'd be happy to help you with your question. To print a single column of data from Excel in multiple columns on a single page, you can use the "Page Layout" options. Here's how you can achieve this:

Open your Excel document with the single column of data.

Highlight the entire column that you want to print in multiple columns. In your case, select cells A1 to A14000.

Go to the "Page Layout" tab in the Excel ribbon.

In the "Page Setup" group, click on the small arrow icon in the lower right corner to open the "Page Setup" dialog box.

In the "Page Setup" dialog box, go to the "Sheet" tab.

In the "Print" section, locate the "Page Order" option and select "Down, then over" from the dropdown menu. This will set the print order to go from top to bottom and then left to right.

In the "Rows to repeat at top" field, if you want to repeat any header rows at the top of each page, you can specify the row range. If not, you can leave it blank.

Click "OK" to close the "Page Setup" dialog box.

Now, go back to the "Page Layout" tab and click on the "Margins" dropdown in the "Page Setup" group.

Choose "Custom Margins."

In the "Page Setup" dialog box that appears, go to the "Margins" tab.

Under the "Multiple pages" section, you can set the number of columns and rows per page. In your example, you want two columns per page, so set "Columns" to 2.

Adjust the other margin settings as needed.

Click "OK" to close the "Page Setup" dialog box.

Now, go to the "View" tab and select "Page Break Preview" to view how your data will be split across pages.

Adjust the page breaks as needed by dragging them to the desired locations. You can have page breaks after every 2 columns in your case.

Once you are satisfied with the page breaks, exit the "Page Break Preview."

You can now go to the "File" tab and choose "Print" to print your Excel document with the data displayed in multiple columns on each page.

This way, Excel will print your single column of data in the specified number of columns per page with page breaks for readability.

Best Regards, Femi