Printing a list into multiple columns per page

I have a list (specifically, DVD's from my home collection and the disk
number in a changer) in Excel2003 which is about six pages long; each
printed page has room for another column of the same data to the right of
what's printed. Is there a way (like in Word, where you can specify 2
column wide printing) in Excel to have a list print with page 1 on the left,
page 2 on the right, etc:
Current format of printing:
title1
title2
title3
title4
title5
etc
title 60
(page break)
title 61
title 62
title 63
etc


Desired printing:
would print as
title1 title 61
title2 title 62
title3 title 63
title4 etc. . .
title5
etc
title 60

As this is a dynamic list, with new titles being added and sort orders being
changed, I really don't want to simply move data around, but have it totally
within the print setup.

Thanks in advance.

Hi Fred,

Excel doesn't have the same kind of column structure as Word, but there's another way:
.. On a new worksheet in your existing workbook, insert the following formula into A1:
=IF(OFFSET(Sheet1!$A$1,(COLUMN()-1)*60+ROW()-1,0)="","",OFFSET(Sheet1!$A$1,(COLUMN()-1)*60+ROW()-1,0))
.. Copy this formula across as many columns as you need (two per output page - or 12 columns for the 6 pages you mention) and down 60
rows.
.. Format the new worksheet's column widths to suit the data.
.. Format the new worksheet's page layout to fit 2 columns and 60 rows per output page.
The above formula will be impervious to any row insertions/deletions from your data worksheet, except for row 1. It will also be
impervious to changes in sort order on your data worksheet - which it will also reflect.

If your DVD data don't start in A1, you'll need to adjust the formula to suit.

Cheers
[MS MVP - Word]

"Fred" <Fred RemoveThis @deleted.com> wrote in message news:eTFI1DuUHHA.5060@TK2MSFTNGP06.phx.gbl...
>I have a list (specifically, DVD's from my home collection and the disk number in a changer) in Excel2003 which is about six pages
>long; each printed page has room for another column of the same data to the right of what's printed. Is there a way (like in Word,
>where you can specify 2 column wide printing) in Excel to have a list print with page 1 on the left, page 2 on the right, etc:
> Current format of printing:
> title1
> title2
> title3
> title4
> title5
> etc
> title 60
> (page break)
> title 61
> title 62
> title 63
> etc
>
>
> Desired printing:
> would print as
> title1 title 61
> title2 title 62
> title3 title 63
> title4 etc. . .
> title5
> etc
> title 60
>
> As this is a dynamic list, with new titles being added and sort orders being changed, I really don't want to simply move data
> around, but have it totally within the print setup.
>
> Thanks in advance.
>