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.

Sample Dataset: Save Excel as PDF on One Page


Method 1 – Using the ‘Fit To’ Option

STEPS:

  • Click on Page Layout.

Fitting Excel Page to One Page to Save as PDF by Scaling

  • 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

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

Read More: How to Convert Excel to PDF without Converter


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

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

Fitting Excel Sheet on One Page to Save as PDF

  • 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

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

Read More: How to Convert Excel to PDF with All Columns


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.

Setting up the Page by Defining Print Area, Page Size, Margin, and Orientation

  • 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

  • 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

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

Read More: How to Save Excel as PDF without Cutting Off


Download the Practice Workbook

Download the following practice workbook for free.


Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Osman Goni Ridwan
Osman Goni Ridwan

OSMAN GONI RIDWAN is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, OSMAN has transitioned into the role of a content developer. Specializing in creating technical content exclusively centered around Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo