Printing a Column in Multiple Segments on One Page

Owen Leibman · External Since: Jul 14, 2005 Posts: 3

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?

Norman Jones · External Since: Sep 14, 2004 Posts: 594

Hi Owen,

See David McRitchie's Snake Columns page at:

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

---
Regards,
Norman

"Owen Leibman" <OwenLeibman.RemoveThis@discussions.microsoft.com> wrote in message
news:FACA40DD-D6C1-4883-B521-B834111C54B0@microsoft.com...
>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?

ScottO · External Since: Jul 02, 2005 Posts: 158

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" <OwenLeibman DeleteThis @discussions.microsoft.com> wrote in
message news:FACA40DD-D6C1-4883-B521-B834111C54B0@microsoft.com...
| 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?

Owen Leibman · External Since: Jul 14, 2005 Posts: 3

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" <OwenLeibman.RemoveThis@discussions.microsoft.com> wrote in message
> news:FACA40DD-D6C1-4883-B521-B834111C54B0@microsoft.com...
> >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?
>
>
>

Owen Leibman · External Since: Jul 14, 2005 Posts: 3

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" <OwenLeibman RemoveThis @discussions.microsoft.com> wrote in
> message news:FACA40DD-D6C1-4883-B521-B834111C54B0@microsoft.com...
> | 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?
>
>
>

shari · External Since: Nov 27, 2006 Posts: 1

"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?