EXCEL HOW TO CHANGE DEFAULT PRINTER PDF
EXCEL HOW TO CHANGE DEFAULT PRINTER WINDOWS 8

If you are not sure where it is located, simply type it in your Metro search box and locate in the settings category. first find the Group Policy control panel to change the settings. It requires you to change a specific Group Policy.ДЎ.

EXCEL HOW TO CHANGE DEFAULT PRINTER WINDOWS 8

There is also a way how to select the XPS format as default choice in Windows 8 for the Microsoft XPS Document Writer. window Changing the Microsoft XPS Document Writer default format in Windows 8 function, in which you can pick what format to use. You can manually select in which format the XPS Writer saves your document using the File - Save as. The former is much easier than the latter.Manually selecting XPS format insteadВ OXPS

EXCEL HOW TO CHANGE DEFAULT PRINTER PDF

Either, you select the Adobe PDF option under your printer options, or change the configuration of the spreadsheet so that you don't need to apply a scaling factor to print (i.e. Therefore, in Excel, if you use a scaling factor to adjust your spreadsheet to fit a page size, then it's not advisable to use the 'Save as Adobe PDF' option under 'File'. Seems like it's a bug in the program because why else would the page size be adjusted based on the scaling factor? The 85% scale that I had applied to make my sheet fit on a letter-size page had adjusted the size of the PDF page. Using some simple math, I realized that 8.5' is 85% of 10', and 11.5' is 85% of 12.94'.

After printing, the resulting page size of the PDF was 10' x 12.94' (i.e.

The default page size was set to letter (8.5' x 11'). You can use the 'fit to page' option, but I wanted to see if a manually-entered scale factor would help me understand why PDF size changes.ДЄfter applying the scale, I printed the PDF using the 'Save as Adobe PDF' which is the same as the 'Create PDF' from the 'Adobe' tab in the ribbon at the top of the screen. I set my scale to 85% which would allow the sheet to be printed on as single page. I was provided a spreadsheet that should be on a single page, but due to the column and row sizes, the contents extend into the next pages in both horizontal and vertical directions, which would result in 4 hardcopy pages. In Excel, the scaling factor will determine the size of the resulting page size when using the 'Save as Adobe PDF' option. I discovered the reason why the page sizes don't match the intended page size when using the 'Save as Adobe PDF' option. No matter what settings I try on the Create PDF dialogue box, the resulting page is a random size not related to the page size set in Excel.Д¬an anyone help resolve this issue? I tried attaching screenshots of the various settings but can't seem to add them here. 'Entire workbook' or 'Sheet(s)' and 'Fit to paper width' or 'Fit worksheet to a single page' the resulting pdf print is 627.1mm x 443.4mm '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.

Excel how to change default printer