Printing a list into multiple columns per page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fred - 17 Feb 2007 22:14 GMT

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.

Reply to this Message

macropod - 18 Feb 2007 09:58 GMT

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]

>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,
[quoted text clipped - 27 lines]
>
> Thanks in advance.

Reply to this Message

Fred - 19 Feb 2007 22:07 GMT

Thanks!

> Hi Fred,
>
[quoted text clipped - 53 lines]
>>
>> Thanks in advance.

Reply to this Message