Top

4 Simple and Fast Methods to Convert Excel to PDF and Fit to Page

Converting Excel files to PDF while ensuring they fit on one page can be challenging, especially for users who are not well-versed in Excel. This can lead to frustration when printed sheets are split across multiple pages, wasting paper and making documents difficult to read.

In this article, we’ll explore four simple methods to convert Excel to PDF and fit it onto one page, ensuring your documents look professional and are easy to share.

Converting Excel files to PDF and Fit to Page:

  • Print Excel to PDF: In Microsoft Excel, click File > Print > Settings > No scaling and tick Fit Sheet on One Page.
  • Use Page Setup: In Microsoft Excel, Click Page Layout > Dialog Box Launcher. In the Page Setup dialog box, click Page and choose 1 in the Fit to box.
  • Avoid Page Breaks: Go to View > Page Break Preview and move the page break to include the whole sheet on one page.
  • Print Excel to PDF with PDFelement: Go to Print setting, and set up one page per sheet.

Method 1. Print Excel to PDF by Fitting the Sheet on One Page

The easiest way to convert Excel to PDF and fit it on one page is by adjusting the scaling settings. Here’s how:

Step 1. Select an Excel to PDF Printer

Launch Microsoft Excel and open an Excel sheet that you want to save as PDF and fit on one page. Click File > the Print option to access the printing settings. Select the printer Microsoft Print to PDF.

If you have Wondershare PDFelement - PDF Editor Wondershare PDFelement Wondershare PDFelement installed, select PDFelement as the printer. The advantage of printing Excel to PDF with PDFelement is that you can edit the converted PDF files with this powerful PDF editor afterward, for example, editing text, adjusting page layout, and more.

Try It Free Try It Free Try It Free Try It Free
star icon G2 Rating: 4.5/5 | 100% safe100% Secure
star icon G2 Rating: 4.5/5 |seguridad garantizada100% Secure

Step 2. Excel to PDF Fit to One Page

To fit the Excel spreadsheet to one page, click on No Scaling under Settings and choose Fit Sheet on One Page; now hit the Print button.

A dialog box will appear, and here you have to enter a name, choose a location where you want to save the file, and hit the Save button to print Excel to PDF in one page.

Excel to PDF Fit on One Page

Method 2. Convert Excel to PDF in One Page via Page Setup

Another effective way to ensure your Excel data fits onto a single page is through the Page Setup option.

Step 1. Open Page Setup Settings

We would assume that you have already opened an Excel file with Microsoft Excel. Now click on the Page Layout tab, and in this tab, you have to click on a tiny Dialog Box Launcher appearing on the bottom-right. It will result in displaying the Page Setup dialog box.

Step 2. Fit Excel to One Page

Click on the Page tab in the dialog box. Click on Fit under the Scaling in the Page tab in the dialog box. You have to choose 1 in both the boxes that are next to the Fit to option. Excel will shrink all the data into one page, and you will click on the OK button to save the setting.

Step 3. Convert Excel to PDF in One Page

Now you click Files > Save as and save the Excel file in PDF format on your computer.

Excel to PDF Fit on One Page

If you still can't get all contents of a spreadsheet on one page, follow method 3 to adjust Page Break to fix the problem.

Method 3. Convert Excel to PDF Without Page Breaks

Excel always adds page breaks automatically, which can lead to content being split across pages. Here’s how to adjust this:

Step 1. Open Page Breaks

Go to the View tab and click "Page Break Preview". The automatic page breaks added will appear on your sheet.

Step 2. Adjust Page Breaks

You can move the page break to include everything on your sheet to one page without a page break. Put your cursor on the blue line and drag it in the direction in your need. Release when you finish. The content inside the blue lines will be saved on one page.

Now you can go to Files > Print and print the Excel to one PDF page.

Excel to PDF Fit on One Page

Method 4. Print Multiple Excel Sheets to PDF on One Page

If you want to convert a whole workbook with multiple worksheets to one page in PDF format, this is the one that will fit your needs. In this method, we will use Wondershare PDFelement - PDF Editor Wondershare PDFelement Wondershare PDFelement a well-known PDF viewer and editor to convert Excel to PDF without compromising the document's quality or format.

It comes with editing tools that allow you to even edit once the Excel files are converted into PDFs. You can add media such as images and annotations as well. Besides the conversion, you can create PDF editable forms that will help the users get real-time information from the customers, add text to PDF, and more.

Step 1. Downloading and installation

The very first step that initiates the process is the installation of PDFelement. It's elementary to download as you can get it from the link provided below and install it as per the instructions available in the installation setup.

Try It Free Try It Free Try It Free Try It Free
star icon G2 Rating: 4.5/5 | 100% safe100% Secure
star icon G2 Rating: 4.5/5 |seguridad garantizada100% Secure

Step 2. Load Your Excel File

Launch the PDFelement on your computer and navigate to the Home window. Click on the Create PDF icon and locate the Excel file you want to convert to PDF. Load it and open it.

Excel to PDF

Step 3. Setting up for Excel to PDF

Then click on Convert and go to Print Settings. Here you have to choose the number of pages per sheet to add all the worksheets into one page. Then click on Save to keep this PDF on your computer.

Multiple Excel Sheets to One Page

Tip: PDFelement is available online now. PDFelement Online can easily help you convert Excel to PDF, Word to PDF, PPT to PDF or vice versa online without installation.

How to Save Excel Sheet as PDF without Cutting Off 

Sometimes, when you export an Excel spreadsheet to PDF, you may notice that some columns are missing, text is cut off, or data is split awkwardly across multiple pages. This usually happens when the worksheet is wider or longer than the selected paper size.

It's important to distinguish this issue from fitting an Excel sheet onto one page. Fit Sheet on One Page scales the entire worksheet to fit on a single PDF page, while saving Excel as PDF without cutting off focuses on keeping all data visible and readable, even if the PDF contains multiple pages.

For example, if your spreadsheet contains dozens of columns and hundreds of rows, forcing everything onto one page may make the text too small to read. In this case, it's better to let the worksheet span multiple pages while ensuring that no columns or data are cut off.

Here are several ways to achieve this:

1. Change the Page Orientation to Landscape

If your spreadsheet contains many columns, the default portrait orientation may not provide enough horizontal space, causing some columns to be pushed onto separate pages or cut off in the print layout.

To fix this:

1.Open your Excel worksheet and go to the Page Layout tab.

2.Click Orientation and select Landscape.

3.Go to File > Print to preview the layout.

4.Check whether all columns fit within the page width before saving the file as PDF.

Landscape orientation provides more horizontal space, making it particularly useful for wide spreadsheets.

Change Page Orientation to Landscape

2. Fit All Columns on One Page

If your Excel worksheet contains many columns, you can use Excel's Fit All Columns on One Page setting to keep them together within a single page width. Unlike Fit Sheet on One Page, this option does not force the entire worksheet onto a single page. Instead, it scales the columns to fit the page width while allowing rows to continue across multiple pages vertically.

Follow these steps:

1.Open your worksheet and select the Page Layout tab.

2.Find the Scale to Fit section.

3.Set Width to 1 page.

4.Set Height to Automatic.

5.Open File > Print to check the preview.

If the layout looks correct, save or export the worksheet as PDF.

With this setting, every PDF page can display all the worksheet's columns, while rows are automatically distributed across multiple pages as needed. It's particularly useful for wide spreadsheets because it prevents columns from being split horizontally across pages without shrinking all the data onto a single page.

Fit All Columns on One Page