Printing two columns from one

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SystemHack - 20 Dec 2005 06:45 GMT

My spreadsheet is only two columns side by side but it spams down 16
pages. I would like to be able to put 2 sets of the two columns on each
page but excel wont sort information across multiple columns. Any idea
how I could sort the main column but have it print two sets to conserve
paper ? sorry if this doesnt make sense I wasnt sure exactly how to word
it.

Signature

SystemHack

Reply to this Message

Andy - 20 Dec 2005 08:52 GMT

Hi

Have a look here:

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

Hope this helps!
Andy.

> My spreadsheet is only two columns side by side but it spams down 16
> pages. I would like to be able to put 2 sets of the two columns on each
> page but excel wont sort information across multiple columns. Any idea
> how I could sort the main column but have it print two sets to conserve
> paper ? sorry if this doesnt make sense I wasnt sure exactly how to word
> it.

Reply to this Message

Dave Peterson - 20 Dec 2005 14:48 GMT

I sometimes just copy the table into MSWord and use Format|Columns to save paper
when I print.

> My spreadsheet is only two columns side by side but it spams down 16
> pages. I would like to be able to put 2 sets of the two columns on each
[quoted text clipped - 8 lines]
> SystemHack's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26614
> View this thread: http://www.excelforum.com/showthread.php?threadid=494800

Signature

Dave Peterson

Reply to this Message