[Fixed!] Excel to PDF Size Problem While Printing

Microsoft Excel is considered one of the most valuable tools currently accessible. With Excel’s tools and capabilities, it is feasible to perform an endless number of actions on a dataset. Regularly publishing Excel sheets as PDFs force us to confront the issue of paper size. In addition, you have experienced a problem in which your Excel spreadsheet prints on numerous pages instead of one. This article will discuss four causes and solutions for the Excel to PDF size issue. Therefore, it is recommended that you go through these Four quick solutions to fix Excel to PDF Size Problem.

How to Fix Excel to PDF Size Problem While Printing: 2 Reasons With Solutions

We’ll look at a sample dataset as an example. For example, the dataset below has Product Names and Monthly Sales columns. Using all four methods, we will turn the Excel sheet into a PDF and keep the size and other properties the same. The first solution of first reason in this article shows how to use the Print Option to solve Excel to PDF size problems. In contrast, the second one uses the Scale to Fit group to solve the issues. Last but not least, we will fix the size problem from Excel to PDF by running Excel VBA code. Throughout the second reason, we’ll figure out what to do when your Excel document prints on more than one page. I’ve been writing this essay with Microsoft Excel 365. You can choose the edition that works best for you.

Reason 1: Scale of Excel Properties Is not 100%

To scale something means to reduce or increase its size. Whenever the Scale of the Excel properties is less than 100%, we need to get the actual size of the contents while printing as a PDF.

Solution 1: Utilize Print Option to Solve Excel to PDF Size Problem

Inside the Print Option, different editable fields are shown based on the needs of printing from Excel to PDF. We will solve the size problem by using the Print option to create a PDF from Excel. Please follow these instructions closely if you want to finish the assignment well.

STEPS:

• First of all, choose the intended sheet as the Active sheet.
• Secondly, go to the File tab.

• Due to this, a new user interface will appear.
• Later, from the left pane, choose Print, then click

No Scaling → No Scaling → Print

• Subsequently, a window will open to input the file name and destination.
• Now, write the file name and destination and hit Save.

• Finally, open the saved PDF file to see the desired output.
• Thus, we solved the Excel to PDF size problem.

Read More: How to Convert Excel to PDF without Converter

Solution 2: Illuminate Excel to PDF Size Problem from Scale to Fit Group

Utilizing the Scale to Fit group is another intriguing solution to the size problem. To complete the assignment, kindly pay close attention to the directions provided.

STEPS:

• To begin, select the desired sheet as the Active sheet.
• Secondly, navigate to the Page Layout tab.
• After that, from the Scale to Fit group, change both Width and Height to 1 page.

• Now, press  Ctrl + P .
• Later, click the Print icon.

• Consequently, a window will appear to take the file name and destination.
• Type the name, choose the destination, and tap the Save button.

• At this point, open the file.
• Finally, it will display to intended output as follows.
• Hence, we overcome the size issues.

Read More: How to Convert Excel to PDF without Losing Formatting

Solution 3: Run an Excel VBA Code to Fix Size Problem from Excel to PDF

In this last case, when we print an Excel file as a PDF, we will run some VBA code to fix the size problem. Please do the task by following these steps.

STEPS:

• First, choose the Excel sheet and navigate to the Developer tab.
• Secondly, click the Visual Basic icon.

• After that, click Insert, followed by Module.

• Presently, input the following code in the Module Box.

Sub FixSizeProblemExcelToPDF()
    Application.PrintCommunication = True
    ActiveSheet.PageSetup.PrintArea = "$B$2:$F$10"
    Application.PrintCommunication = False
    With ActiveSheet.PageSetup
        .PrintHeadings = False
        .PrintGridlines = False
        .PrintComments = xlPrintNoComments
        .CenterHorizontally = False
        .CenterVertically = False
        .Orientation = xlPortrait
        .Draft = False
        .PaperSize = xlPaperLetter
        .FirstPageNumber = xlAutomatic
        .Order = xlDownThenOver
        .BlackAndWhite = False
        .PrintErrors = xlPrintErrorsDisplayed
        .OddAndEvenPagesHeaderFooter = False
        .DifferentFirstPageHeaderFooter = False
        .ScaleWithDocHeaderFooter = True
        .AlignMarginsHeaderFooter = True
    End With
    Application.PrintCommunication = True
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
        IgnorePrintAreas:=False
End Sub

• Later, press  F5  or click the Run symbol.

• Subsequently, the Windows Explorer window will appear to take the file name and destination.
• Next, type the PDF name, choose the destination, and hit the Save button.

• Currently, open the saved file with any PDF reader.
• Thus, the issues will disappear, producing the intended outcome like the one below.

Read More: How to Deal with Margin Problem While Converting Excel to PDF

Reason 2: Extra Columns in Excel Dataset

When there are unusually many columns in the dataset, spreadsheets in Excel take up several pages when printed.

Solution: Maintain Page Dimension Using Print Option While Exporting as PDF

We may have run into an issue where the Excel document is published on multiple pages. Here we’ll go through how to export an Excel file to PDF while keeping all the columns in the view. To do so, we will add new columns to the dataset we used earlier, which included sales figures for each month of the year. You must pay close attention to these directions to understand this assignment well.

STEPS:

• First of all, choose the Active sheet.
• Secondly, go to the File tab.

• Later, click on the Print option.
• It is important to note that, in the right pane, we find our sheet columns break and will print on more than one page.

• Currently, to solve the issue, we will click on

No Scaling → Fit All Columns on One → Print

• Due to this, Windows Explorer will open up.
• At this time, write the name and pick the destination of the PDF, followed by clicking the Save button.

• Consequently, after opening the PDF file, the output will display like the below one containing all the columns.

Download Practice Workbook

You are welcome to get a free copy of the sample workbook we referred to throughout the presentation by clicking on the link immediately below.

Conclusion

You can apply the procedures we covered to solve the Excel to PDF Size Problem. Continue using them, and let us know if you think of any different ways to complete the task or have other suggestions. Remember to submit questions, comments, or recommendations in the space below.

Related Articles

• How to Convert Excel to PDF with All Columns
• How to Save Excel as PDF on One Page
• How to Save Multiple Excel Sheets as One PDF
• How to Create a Fillable PDF from Excel
• [Fixed!] Excel to PDF Hyperlinks Not Working
• How to Save Excel as PDF without Cutting Off
• Export Excel to PDF with Hyperlinks

<< Go Back to Export Excel to PDF | Export Data from Excel | Learn Excel