I have an excel spreadsheet with only one column. 243 lines long though. The
column is not big and i could fit 3 of the columns on one page but if i
seperate the spreadsheet into multiple columns i cant alphabetize the columns
all together. Also i want to be able to go back and add additional rows and
realphabetize the rows later. How can i get excel to fill up my pages with
the same column and only have 2 pages instead of 7 like it wants to. At work
I had a document what was setup to read like a very long column but it was a
..txt document. When i printed it out in wordpad i found an option in either
the printer or wordpad settings that let you print more that one page on a
page. sounds weird but it worked good.

Depending on what you're doing, you may want to move your list into MSWord and
update it there.

You can format the output to multiple columns and sorts work fine, too.

If moving the list isn't a solution, you could copy and paste into MSWord and
print it there. (Do this when ever you want to print it).

If you don't like that, you can look at David McRitchie's SnakeCols routine.
Keep your data in a list and run his routine right before you want to print.

http://www.mvps.org/dmcritchie/excel/snakecol.htm

Longhorn bound wrote:

I have an excel spreadsheet with only one column. 243 lines long though. The
column is not big and i could fit 3 of the columns on one page but if i
seperate the spreadsheet into multiple columns i cant alphabetize the columns
all together. Also i want to be able to go back and add additional rows and
realphabetize the rows later. How can i get excel to fill up my pages with
the same column and only have 2 pages instead of 7 like it wants to. At work
I had a document what was setup to read like a very long column but it was a
.txt document. When i printed it out in wordpad i found an option in either
the printer or wordpad settings that let you print more that one page on a
page. sounds weird but it worked good.

--

Dave Peterson