Page 1 of 1

Predefined Page Size

Posted: Tue Feb 07, 2017 1:24 pm
by MuleTrain
I have created an Excel report that I have set up to print 11x17. When I choose Print, doPDF, and save as a PDF file, I was hoping it would retain the settings. But when I open the PDF file with Adobe Acrobat Reader, it is defaulting to 8.5x11. Am I doing something wrong with the steps I am using? I thought I had read that doPDF would do predefined page sizes.

Thanks,
Brad

Re: Predefined Page Size

Posted: Wed Feb 08, 2017 6:19 am
by marjohn
Hi Brad,

I'm using Excel 2003, but the process should be much the same for you in whatever version you're using.

These are the steps for me:

File
Page Setup
Options - which opens a doPDF dialog
Select 'Custom' and enter Width, Height, and Units
OK, and then 'Print' (or 'Print Preview' if you want to see how it looks)

That's it! Good luck, hope it works for you. :)

Cheers,

John