Discussion Locked
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.
I was hoping for a better solution than this.
by dklippert
Here's a collection of other workarounds:
www.mvps.org/dmcritchie/excel/snakecol.htm
Poster rated this answer.
This question was closed by the author
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
0 helpful
20 replies
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
4 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies