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
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![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks