How to Save Excel as a PDF on One Page (3 Easy Methods)
![Sample Dataset: Save Excel as PDF on One Page](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-1.png)
This dataset includes bank account openings. The data couldn’t be saved on the page as a PDF.
Method 1 – Using the ‘Fit To’ Option
![Fitting Excel Page to One Page to Save as PDF by Scaling](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-2.png)
- Click on the little Dialog Box Launcher in the right bottom corner.
A Page Setup window will appear.
![Fitting Excel Page to One Page to Save as PDF by Scaling](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-3.png)
- Don’t exit from the Page tab.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-4.png)
- Select the Fit to button under the Scaling section. Choose 1 page(s) wide by 1 tall in the Fit to boxes. Select a suitable Paper size you need to print it.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-5.png)
- Press OK to close the Page Setup dialog box
- To save the file as PDF directly, Press File > Save As, select Location, and select PDF in the Save As Type drop-down menu.
- Press the Save button.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-6.png)
Method 2 – Using the ‘Fit Sheet on One Page’ Option
STEPS:
- Click on the File tab in the top-left corner of the window.
![Fitting Excel Sheet on One Page to Save as PDF](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-7.png)
- Click the Print option on the left side of the window.
![Fitting Excel Sheet on One Page to Save as PDF](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-8.png)
- Press the No Scaling drop-down under the Settings section. And other options will appear.
![Fitting Excel Sheet on One Page to Save as PDF](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-9.png)
- Select the Fit Sheet on the One Page option.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-10.png)
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-11.png)
- Click on the Save As Type menu; other options will appear. Select the PDF option to save as PDF.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-12.png)
Note: This setting allows us to print large spreadsheets in very small sizes . For better results, you might also try the Fit All Columns on One Sheet or the Fit All Rows on One Sheet option.
Method 3 – Setting up Page Layout
STEPS:
The page layouts and margins won’t be visible in Excel. You have to set up the page layout.
- Click on the Page Layout option on the ribbon bar.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-13.png)
- Find Margins, Orientation, Size, and Print Area. All four elements are to be set up before saving them as PDFs.
- Press the Margins button.
- Select one from the drop-down menu. If you want to set up a margin yourself, select Custom Margins.
![Setting up the Page by Defining Print Area, Page Size, Margin, and Orientation](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-14.png)
- The Excel page is in Portrait Orientation. You can change the landscape orientation for a large number of columns.
- Press on the Orientation drop-down and select the Landscape option
![Setting up the Page by Defining Print Area, Page Size, Margin, and Orientation](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-15.png)
- Page size is the most important factor for fitting data into a single page. Some columns can be out of margin without proper page size for printing.
- Press the Size drop-down and select anyone as per your requirement from the drop-down menu. We usually use A4.
![Setting up the Page by Defining Print Area, Page Size, Margin, and Orientation](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-16.png)
- After setting up the page size, some Dashed lines will be visible. You can change the column and row size manually to fit the sheet on one page.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-17.png)
- Select all the cells that you want to print. Then Click on Print Area > Set Print Area.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-18.png)
- Set the Width and Height to 1 Page in the Scale to Fit Section to save selected Cells on 1 page.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-19.png)
- Press FIle > Save As and select PDF in the Save As Type drop-down menu. Then Press Save.
You can also save pdf from print options.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-20.png)
- Click File > Print or press CTRL P to go to the print option, Press Microsoft Print to PDF from Printer List, and Press Print.
- Save Print Output As window will appear. Select the location to save your file, enter a suitable file name, and press Save to save your file as PDF on one page.
![](https://www.exceldemy.com/wp-content/uploads/2022/04/How-to-save-excel-as-pdf-on-one-page-21.png)
Download the Practice Workbook
Download the following practice workbook for free.
Save as PDF on One Page.xlsx
Related Articles
- How to Convert Excel to PDF without Losing Formatting
- Export Excel to PDF with Hyperlinks
- How to Save Multiple Excel Sheets as One PDF
- How to Create a Fillable PDF from Excel
- How to Deal with Margin Problem While Converting Excel to PDF
- [Fixed!] Excel to PDF Size Problem While Printing
- [Fixed!] Excel to PDF Hyperlinks Not Working