Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Printing a Column in Multiple Segments on One Page
I have a list of names in a spreadsheet column. The data takes up, say, 1/4
of the page horizontally. Let's say I have 200 names, and want to print them in columns of 50. In other words, they should all be able to fit on one page - 1-50 in column 1, etc. I can cut and paste, but that's rather labor intensive. I can print 4-up, but that reduces the font size so that it's practically invisible. Is there anything else I can do? |
#2
|
|||
|
|||
If you go to this site
http://www.asap-utilities.com/ you can download a "toolbox" full of all sorts of neat tricks. One of the tricks (called "Paper Saver") does *exactly* what you want. Rgds, ScottO "Owen Leibman" wrote in message ... | I have a list of names in a spreadsheet column. The data takes up, say, 1/4 | of the page horizontally. Let's say I have 200 names, and want to print them | in columns of 50. In other words, they should all be able to fit on one page | - 1-50 in column 1, etc. | I can cut and paste, but that's rather labor intensive. | I can print 4-up, but that reduces the font size so that it's practically | invisible. | Is there anything else I can do? |
#3
|
|||
|
|||
Hi Owen,
See David McRitchie's Snake Columns page at: http://www.mvps.org/dmcritchie/excel/snakecol.htm --- Regards, Norman "Owen Leibman" wrote in message ... I have a list of names in a spreadsheet column. The data takes up, say, 1/4 of the page horizontally. Let's say I have 200 names, and want to print them in columns of 50. In other words, they should all be able to fit on one page - 1-50 in column 1, etc. I can cut and paste, but that's rather labor intensive. I can print 4-up, but that reduces the font size so that it's practically invisible. Is there anything else I can do? |
#4
|
|||
|
|||
Thanks - looks very promising!
"Norman Jones" wrote: Hi Owen, See David McRitchie's Snake Columns page at: http://www.mvps.org/dmcritchie/excel/snakecol.htm --- Regards, Norman "Owen Leibman" wrote in message ... I have a list of names in a spreadsheet column. The data takes up, say, 1/4 of the page horizontally. Let's say I have 200 names, and want to print them in columns of 50. In other words, they should all be able to fit on one page - 1-50 in column 1, etc. I can cut and paste, but that's rather labor intensive. I can print 4-up, but that reduces the font size so that it's practically invisible. Is there anything else I can do? |
#5
|
|||
|
|||
Thanks - looks very promising.
"ScottO" wrote: If you go to this site http://www.asap-utilities.com/ you can download a "toolbox" full of all sorts of neat tricks. One of the tricks (called "Paper Saver") does *exactly* what you want. Rgds, ScottO "Owen Leibman" wrote in message ... | I have a list of names in a spreadsheet column. The data takes up, say, 1/4 | of the page horizontally. Let's say I have 200 names, and want to print them | in columns of 50. In other words, they should all be able to fit on one page | - 1-50 in column 1, etc. | I can cut and paste, but that's rather labor intensive. | I can print 4-up, but that reduces the font size so that it's practically | invisible. | Is there anything else I can do? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing a Column in Multiple Segments on One Page
"Owen Leibman" wrote: I have a list of names in a spreadsheet column. The data takes up, say, 1/4 of the page horizontally. Let's say I have 200 names, and want to print them in columns of 50. In other words, they should all be able to fit on one page - 1-50 in column 1, etc. I can cut and paste, but that's rather labor intensive. I can print 4-up, but that reduces the font size so that it's practically invisible. Is there anything else I can do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and count words | Excel Worksheet Functions | |||
generate multiple rows based on cell value | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
Printing the last column on every page printed. | Excel Discussion (Misc queries) |