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?

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?

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?

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?

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?

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?