Print multiple excel worksheets on one page 1

[hdat44]

Hi, is it possible to print multiple worksheets on one page?? i've tried printing entire workbook and then selecting multiple pages in the layout tab but they still print out on seperate pages?? is this doable??

 

[xlhelp]

On Page layout tab, click the small arrow under Page Setup group. Choose options (it's on one of the tabs).

In the resulting dialog box select the features tab. Choose your option under Pages per Sheet.



Avoid Hangovers. Stay drunk.

 

[hdat44]

hi, i have tried this and they all print out on seperate pages for example i have 11 worksheets, so under layout i selected the option for 16 pages per sheet, and it printed the 11 pages out seperatly

 

[SkipVought]

Hi,

This is Excel working as designed. You have to realize that each sheet (table) may have different headings/data structure, so data may not be consistent, so each sheet needs complete isolation from another.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[hdat44]

So i guess you mean the cells need to be the same size etc, a lot of the pages are different charts / graphs etc... does this mean that its not going to work??

 

[combo]

If it's necessary, It's not a problem to have one report sheet with everything that has to be printed. Just add a new worksheet and paste charts, links and formats of existing data.

combo

 

[hdat44]

Hi, i have found a solution, i just pasted easch page into one using past as a picture, fit to one page and perfect... thanks for all who helped

 

[SkipVought]

You could use the CAMERAL feature.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[hdat44]

Cameral???

 

[SkipVought]

Excel Options > Customize > Choose commands from ALL COMMANDS and scroll down to CAMERA.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ladyck3]

OH COOOOOOOOOOOOOOOOOOOOOOOOLLLLLLLLLLLLLLLLLLLLL... Skip you are a GENIOUS, had no idea this existed...and it sure would have saved me countless numbers of hours in the past 10 yrs

KUDOS and THANKS to HDat44 for coming up with the question... YAY

ladyck3
aka: Laurie

 

[SkipVought]

If you make the REFERENCE for the picture a Dynamic Named Range like Print_Area, when the print area changes, then the Camera picture also changes!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

faq68-7518

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}