How to Save Excel as a PDF on One Page (3 Easy Methods)

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

• Click on the little Dialog Box Launcher in the right bottom corner.

A Page Setup window will appear.

• Don’t exit from the Page tab.

• 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.

• 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.

Method 2 – Using the ‘Fit Sheet on One Page’ Option

STEPS:

• Click on the File tab in the top-left corner of the window.

• Click the Print option on the left side of the window.

• Press the No Scaling drop-down under the Settings section. And other options will appear.

• Select the Fit Sheet on the One Page option.

• Click the Save As button in the left column.

• Click on the Save As Type menu; other options will appear. Select the PDF option to save as PDF.

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.

• 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.

• 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

• 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.

• 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.

• Select all the cells that you want to print. Then Click on Print Area > Set Print Area.

• Set the Width and Height to 1 Page in the Scale to Fit Section to save selected Cells on 1 page.

• 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.

• 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.

Download the Practice Workbook

Download the following practice workbook for free.

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