Printing 2 print areas on one sheet

**isalmon** · 10-09-2018, 03:51 PM

Good Afternoon,

i am looking to print some work sheets and due to the formatting they have been set up as follows:

Print area 1 - column A to Z order form template.
Print area 2 - column AA - AH images matching product on order form.

due to the row and column sizing of the order form format i can't have the image below as the sheet just looks like crap...

but now i need to print and would prefer they print on one sheet as there is plenty of room.... how do i get this to happen? is it even possible??

thanks in advance
ian

**6StringJazzer** · 10-09-2018, 07:29 PM

A:Z and AA:AH is a contiguous set of columns, so it is not really two print areas, it's one big print area. From your description, it is unclear what your problem is.

If you go to Page Setup, Page tab, "Fit To" with 1 pages wide by 1 pages tall it will all print on one sheet.

**isalmon** · 10-10-2018, 08:50 AM

Morning All,

Yeah i just re-read my post and it is not clear at all... end of the day i guess my head was a little fried!

I have made a dummy sheet, the format is accurate but none of the info is real...

Basically when i try to print on 1 sheet it puts them side by side, i'm looking to have them print with the order form section on the top or the page and the images on the bottom...with the sheet landscape.

if there is another solution then i'm open to suggestions but i can't change the format of the order form section.

Thanks in advance for any time spent on this problem of mine!
Cheers
Ian