making multiple columns when printing long datasheet
 

Hi, I have a slight problem where I need a solution for, perhaps anyone can
help me.

I have around 2000 dvds in and made a simple Excel sheet. The sheet has 3
columns: book number, page number and title. When I print the sheet, there is
obviously a lot of white space on the right hand side of the pages, since the
3 columns only take up half of the page.

Now I would like to know if it is possible to print the 2nd page (3 columns)
next to the 3 columns of the first page. Thus the alphabetical order remains
intact. Basically I want page 1 and 2 all printed on page 1.

Obviously I can do it by cutting and pasting, but I am wondering if there is
a simpler solution for this annoying problem.

Thanks,
Piet

making multiple columns when printing long datasheet
 

See:

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

Regards
Rowan

Piet wrote:
Hi, I have a slight problem where I need a solution for, perhaps anyone can
help me.

I have around 2000 dvds in and made a simple Excel sheet. The sheet has 3
columns: book number, page number and title. When I print the sheet, there is
obviously a lot of white space on the right hand side of the pages, since the
3 columns only take up half of the page.

Now I would like to know if it is possible to print the 2nd page (3 columns)
next to the 3 columns of the first page. Thus the alphabetical order remains
intact. Basically I want page 1 and 2 all printed on page 1.

Obviously I can do it by cutting and pasting, but I am wondering if there is
a simpler solution for this annoying problem.

Thanks,
Piet