Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing multiple pages onto one page
I have a very wide excel table, which prints out very small on the largest
paper that is available to me. I would like to split the table into two parts, the left half and the right half and have them print on one page, one part below the other. The problem is that the column widths need to be different for each section and putting them one below the other does not allow me to specify distinct column widths for each section. Is there a way to print these two segments on one page, allowing for unique column widths. Any suggestions would be appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing multiple pages onto one page
Hi Kevin,
In Excel 2003, Select the right section, Edit - Copy Select a cell below the left section Hold the {shift} key down whilst clicking on the menu Edit - Paste Picture Link Right-click the picture, select Format Picture, set fill color in Colors and Lines to automatic. In Excel 2007, Select the right section, click Copy on the Home ribbon Select a cell below the left section Click Paste - As Picture - Paste Picture Link on the Home ribbon Right-click the picture, select Format Picture, set fill color in Colors and Lines to automatic. Ed Ferrero www.edferrero.com I have a very wide excel table, which prints out very small on the largest paper that is available to me. I would like to split the table into two parts, the left half and the right half and have them print on one page, one part below the other. The problem is that the column widths need to be different for each section and putting them one below the other does not allow me to specify distinct column widths for each section. Is there a way to print these two segments on one page, allowing for unique column widths. Any suggestions would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing multiple pages | Excel Discussion (Misc queries) | |||
Printing multiple page worksheets on 1 single page | Excel Discussion (Misc queries) | |||
Printing a sheet onto 4 pages: page 2 is empty. | Excel Discussion (Misc queries) | |||
Multiple pages after printing selected area | Excel Discussion (Misc queries) | |||
sumif on multiple pages?---not just one page | Excel Worksheet Functions |