We often need to save Excel as PDF on one page, but at that time we face troubles when positioning larger Excel Sheets. Often they lose their formatting, Excel files have to be set up in a method that allows the data to be shown without losing its format. To save an Excel as a PDF on one page, here’s what you need to do. tables may split into two pages etc. In this article, you will find 3 easy methods to save Excel as PDF on one page.
Download Practice Workbook
Download the following practice workbook for free.
3 Approaches to Save Excel as PDF on One Page
This dataset includes the data of bank account openings which includes 7 columns and 28 rows. And at first, this data couldn’t be saved on the page as a pdf. So, I have tried and solved this problem. In this article, I am sharing 3 easy ways to save Excel files as PDFs on one page.
1. Using the ‘Fit To’ Option to Save Excel as PDF
By scaling the worksheet for saving as PDF, you can fit your data on one page. It is the simplest method. But you will have less control over overfitting the data. It will shrink your excel file to fit on one page. The steps are described below:
- At first, click on Page Layout.
- Then, click on the little Dialog Box Launcher on the right bottom corner.
A Page Setup window will appear.
- Don’t exit from the Page tab.
- Then select the Fit to button under the Scaling section. Choose 1 page(s) wide by 1 tall in the Fit to boxes. And select a suitable Paper size you need to print it.
- At last, press OK to close the Page Setup dialog box
- Then to save the file as PDF directly, Press File > Save As and select Location and select PDF in the Save As Type drop-down menu. Then press the Save button when all is done.
2. Using the ‘Fit Sheet on One Page’ Option to Save as PDF
Another simple method for saving Excel Sheet as PDF on one page is by modifying a setting on the Print menu, then saving the file as a PDF. Follow and execute the steps below.
- At first, click on the File tab in the top-left corner of the window
Then, click the Print option on the left side of the window.
- After that, Press on the No Scaling drop-down under the Settings section. And other options will appear.
- Select the Fit Sheet on One Page option.
- Then, click the Save As button in the left column.
And click on the Save As Type menu, other options will appear. Select the PDF option to save as PDF.
We can print large spreadsheets in very small sizes with this setting. You might also try Fit All Columns on One Sheet or the Fit All Rows on One Sheet option to get better results.
- Excel VBA to Print As PDF and Save with Automatic File Name
- How to Convert Excel to PDF without Converter (5 Effective Methods)
- Export Excel to PDF with Hyperlinks (2 Quick Methods)
- Excel Macro: Save as PDF with Date in Filename (4 Suitable Examples)
- Print to PDF Using Macro Button in Excel (5 Macro Variants)
3. Setting up the Page Layout to Save Excel as PDF on One Page
In the last two methods, we don’t use page formatting. so we neglected page borders, margins, size, etc. But to make a professional document we have to make the excel file a presentable and printable PDF document. Using this method, you will have full control over the page layout. And you can modify your page layout as per your demand. This method is described step by step below:
- At first, The page layouts and margins won’t be visible in Excel. For this, you have to Set-up the page layout. Just click on the Page Layout option on the ribbon bar.
- There you will find Margins, Orientation, Size, and Print Area. All four of these elements are to be set up before saving as PDF. You can Margine by simply pressing the Margins button. And select one from the drop-down menu. And if you want to set up a margin on your own by selecting Custom Margins.
- Usually, the Excel page is in Portrait Orientation. You can change to landscape orientation for a large number of columns.
Press on the Orientation drop-down and select the Landscape option
- Page size is the most important factor for fitting data into a single page. And for printing, without proper page size, some columns can be out of margin. Press the Size drop-down and select anyone as per requirement from the drop-down menu. Usually, we use A4 in most cases.
- After setting up the page size, some Dashed lines will be visible, which is for showing a single page area. You can change the column and row Size manually to fit the sheet on one page. But it may become cumbersome for large sheets.
- For this, you have to select all the cells that you want to print. Then Click on Print Area > Set Print Area.
- Then Set the Width and Height to 1 Page in the Scale to Fit Section to save selected Cells on 1 page.
- Now, to save the file as PDF directly, Press FIle > Save As and select PDF in the Save As Type drop-down menu. Then Press Save when all is done.
- You can also save pdf from print options. For this, Click File > Print or press CTRL P to go to the print option and Press on Microsoft Print to PDF from Printer List. And Press Print When all are set.
- Then a Save Print Output As window will appear, select the location to save your file, type a suitable file name, and at last press on Save to save your file as pdf on one page.
Usually, we can save Word and PPT files in PDF easily but when it is a matter of Excel files, it gets complicated to save the sheet as PDF on one page. But in this article, we have solved it with 3 very simple methods and guided step by step. The 1st two methods are very easy and quick to save a sheet as a PDF in one page. But in these two methods, you will have less control over the page format. In the last method, you will get full control over the page layout. You can modify it as per your need to make the PDF more presentable and organized. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
- Excel Macro to Save as PDF with Filename from Cell Value (2 Examples)
- Print Range to PDF with VBA in Excel (5 Easiest Examples)
- Print to PDF and Email Using VBA in Excel (2 Useful Cases)
- Excel VBA: Create Invoice and Save PDF Format (with Quick Steps)
- How to Save Multiple Excel Sheets as One PDF (2 Easy Methods)