Discussion Locked

Printing Newspaper Columns in Excel

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I frequently have long lists of numbers sorted in Excel by row with one number per row. When I print this I would like for the rows to print in Newspaper column style so that I can get my whole list of numbers printed on 1 or 2 sheets of paper. For example on my worksheet column A contains the numbers 1-1500 with 1 number in each row and I have 1500 rows. When I print rows 1-50 would print on page 1, rows 51-100 print on page 2 etc. I would like to print the numbers where rows 1-50 print in the space for column A, rows 51-100 print in the space for column B, rows 101-150 print in the space for column C, and etc. Can anyone tell me how to do that without doing a lot of cutting and pasting to get them in the format I want?

5 replies

by dklippert

The only way I can think of is to go to a blank worksheet and enter
=Sheet1!A2 in the first column, =Sheet1A102 in colun B etc.
and then fill the formulas down the sheet.

This discussion is closed to new replies.