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

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.

Sample Dataset: Save Excel as PDF 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:

STEPS:

  • At first, click on Page Layout.

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

  • Then, click on the little Dialog Box Launcher on 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.

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

Read More: Excel VBA: ExportAsFixedFormat PDF with Fit to Page (3 Examples)


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.

STEPS:

  • At first, click on the File tab in the top-left corner of the window

Fitting Excel Sheet on One Page to Save as PDF

Then,  click the Print option on the left side of the window.

Fitting Excel Sheet on One Page to Save as PDF

  • After that, Press on 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 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.

Note:

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.

Read More: How to Convert Excel to PDF with All Columns (5 Suitable Ways)


Similar Readings


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:

STEPS:

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

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

  • 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

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

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

Read More: How to Save Excel as PDF without Cutting Off (4 Suitable Ways)


Conclusion

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.


Related Articles

Osman Goni Ridwan

Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo