#EXCEL FOR MAC PDF SCALING HOW TO#
#EXCEL FOR MAC PDF SCALING CODE#

You might find that the options you selected above don’t provide the exact results that you were looking for. I was tying to automate the production of a weekly review document that pulls data from several excel documents.

#EXCEL FOR MAC PDF SCALING CODE#

Step 8: Click the Save button to create the PDF file. In Excel when I do a normal File>Print action the document comes out as Letter size as my settings indicate, but when I use the VBA code the resulting document comes out in Legal size. Step 7: Click the Save as type dropdown menu, then select the PDF option. Step 6: Click the Save As option in the left column. You might have better results with the Fit All Columns on One Sheet or the Fit All Rows on One Sheet option. Note that large spreadsheets can print very small with this setting. Step 5: Select the Fit Sheet on One Page option. Step 4: Click the No Scaling button under the Settings section. Step 3: Click the Print option in the column at the left side of the window. Step 2: Click the File tab at the top-left corner of the window. Step 1: Open your spreadsheet in Excel 2013. We will then save the spreadsheet as a PDF so that you can easily share it with others, or print it again in that format.

#EXCEL FOR MAC PDF SCALING HOW TO#

The steps below will show you how to adjust the settings on your spreadsheet so that the entire thing fits on one page. How to Fit a Spreadsheet to One Page and Save it as a PDF in Excel 2013 Our guide below will walk you through the process so that you have a PDF file of your data that is easy to print and share with others. Therefore, you might find yourself in a situation where you need to save a spreadsheet as a one page PDF in Excel 2013.įortunately you can achieve this requirement by adjusting a setting on the Print menu, then saving the file as a PDF. Unfortunately the PDF version of an Excel worksheet suffers from the same issues that a printed worksheet does, and you may wind up with a PDF file that contains several unnecessary pages. Saving an Excel spreadsheet as a PDF is a solution that I often use when I have data that I want to share with other people, but I want to avoid giving them the option to easily edit that data.

Excel for mac pdf scaling