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
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies