Lutfor Rahman Shimanto
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 PDF forces 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.
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.
2 Reasons with Solutions to Fix Excel to PDF Size Problem While Printing
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 Perform Custom Scaling in Excel (3 Easy Ways)
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 follow.
- Hence, we overcome the size issues.
Read More: How to Perform Page Scaling in Excel (4 Quick Tricks)
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: [Solved!] Excel Scaling Issues (2 Easy Methods)
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 publishes 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.
Read More: How to Use Scaling Option in Excel (4 Quick Ways)
Conclusion
You can apply the procedures we covered to solve the Excel to PDF Size Problem. There are other such articles on the ExcelDemy Website. 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.
