CHANGE PAPER SIZE PDF PDF

'Entire workbook' or 'Sheet(s)' and 'Actual size' the resulting pdf print is 560.2mm x 396.1mm (this is also the page size I get if I choose Save as and select PDF.

In recent times however, the Acrobat add-in tab has become unreliable for me - if my page size is set to A3 landscape (420mm x 297mm) in Excel, and I use Acrobat/Create PDF and select: However, I prefer to use the add-in Acrobat tab in Excel to generate my pdf prints because it default saves to the same folder the Excel file is held in, saving time, and if the Excel workbook contains several separate sheets, they print out as a collated single PDF with all correct page sizing reflecting the settings in Excel for each sheet (ie a mix of A4 and A3 can be generated if wished).

If I click 'edit' on default settings for standard, on the box that pops up, the default page dimensions for 'standard' are shown as 215.9mm x 279.4mm, which I believe is actually 'Letter' page size - so in the Adobe PDF printer settings, the Adobe PDF page size setting appears to override the page dimensions defined within the 'standard' settings. When printing from Excel (Office 365 version using Win10 Pro), using File/Print and setting Adobe PDF as the printer, the pdf page printed is whatever size I set the page size to be in the 'Page layout' tab of Excel - all good so far. My settings for the Adobe PDF printer are 'default settings - Standard' and 'Adobe PDF page size - A4' or A3 as required. I am in the UK, so my default page sizes are A4, A3 etc. Apologies for bumping this old thread, but I have the same issue with the Acrobat add-in for Excel.

Change paper size pdf