Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to print multiple columns on same page | Excel Discussion (Misc queries) | |||
more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel | |||
Multiple Columns for printing | New Users to Excel | |||
Printing multiple columns on one page | Excel Discussion (Misc queries) |