Printing diverse area on one page

Hi all,

Is it possible to take certain ranges from all over a worksheet and when printing place them all together on one page? I have been trying but the best I can come up with still had each range printing to a separate page.

Cheers,
Marcus

Yes this is possible but you give far to little information to get to a fitting solution.

so some general information
1. You can hide the parts you do not want printed and save that as a Custom view (option under the View menu)

2. You can make a separate sheet that has the area's that need to be printed as Linked pictures (or camera shots)
see: how to : https://chandoo.org/wp/how-to-use-picture-links/
This will give you the flexibility to arrange ranges as a picture to fit them on a page without being limited by cell width or heigt of the sheet

3. You can build a macro that will copy / paste the needed printarea's to a new sheet for printing and delete again after printing.

Thanks for the info Roel,

Yes I guess it was short on info but you have given me some leads I will investigate. Thanks for that and I will be back if I can't apply one of the 3 methods you have outlined above.

Cheers,
Marcus