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.

This dataset includes the data of bank account openings which includes 7 columns and 28 rows. At first, this data couldn’t be saved on the page as a PDF. So, I have tried to solve this problem. In this article, I am sharing 3 easy ways to save Excel files as PDFs on one page.

1. Using ‘Fit To’ Option to Save Excel as PDF on One Page

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.

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

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

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 ‘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, and 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

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.

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.

3. Setting up 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. 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, 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.

Download Practice Workbook

Download the following practice workbook for free.

Save as PDF on One Page.xlsx

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. Please, drop comments, suggestions, or queries if you have any in the comment section below.

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

Get FREE Advanced Excel Exercises with Solutions!

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

1. Using ‘Fit To’ Option to Save Excel as PDF on One Page

2. Using ‘Fit Sheet on One Page’ Option to Save as PDF

3. Setting up Page Layout to Save Excel as PDF on One Page

Conclusion

Related Articles

Leave a reply Cancel reply