Print to pdf - print 2 pages on 1 sheet

[Lawrence S]

When printing to a normal printer there is usually an option to print 2 pages per sheet.
I have not been able to find such settings when printing to a pdf
Does anyone know how to do this?
I am happy to do this manually or via vba code.
Please help

 

[6StringJazzer]

What option are you talking about? There is no option to print two pages on one side of a sheet (like there is in PowerPoint). There is normally an option to print two-sided, that is, two pages on two sides of the same piece of paper. But that option doesn't make sense for a PDF, only for physical paper.

In some PDF readers there is an option to scale multiple pages to each side of a sheet, but that happens as a print option, after the PDF is generated, and it specific to the PDF reader.

Can you be more explicit about what your data looks like, and what you want the PDF to look like?

Here is how my PDF reader (FoxIt) can print multiple pages on each sheet, but as I said, this is not related to Excel:

 

[Lawrence S]

The option from your example is exactly what I want to do. This is available on most pdf readers as well as on the printers themselves but I can seem to find this option when printing to a pdf from Excel.
The only solution I can find is first printing from Excel to a pdf, then opening the pdf and selecting multiple pages per sheet as you selected.
This means that I need to do it in 2 steps (i.e. print it twice) and I cannot automate it via a macro.

 

[6StringJazzer]

There is no way to do this from Excel. Excel does not offer a way to print multiple page images on a single sheet of paper.

The only way I can think of to do this is to create a Word document with a live link to your Excel content. Word does have an option to do this, and can also print it to a PDF. I think it could be done just by configuration without even needing VBA. But to get the layout right would be very specific to your file.

 

[Lawrence S]

Thank you
Nice work around. I will give it a try

 

[6StringJazzer]

I don't know why Word and PowerPoint can print multiple pages per sheet but they never put that in Excel.