Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Save Excel as PDF Fit to Page (5 Easy Ways)

When we convert a large dataset into a PDF file, sometimes the dataset breaks into two pages. It is a common occurrence in our regular professional life. In this article, we will demonstrate five different methods to save Excel as PDF fit to a page. If you are curious about it, download our practice workbook and follow us.


Download Practice Workbook

Download this practice workbook for practice and output files while you are reading this article.


5 Easy Methods to Save Excel as PDF Fit to Page

To demonstrate the approaches, we consider a dataset of 21 employees. We mentioned their ID in column B, their names in column C, gender in column D, residency area in column E, the total number of family members in column F, total income in column G,  and total costs in column H. So, we can say that our dataset is in the range of cells B4:H25. Now, if you try to save this dataset into PDF the table will break into two pages. We will show you how to fix it.


1. Using Print Option

In this approach, we are going to use the features of Excel’s built-in Print option to fit the dataset into a page. The steps of this method are described below:

📌 Steps:

  • First of all, click File > Print. Besides it, you can also press ‘Ctrl+P’ to launch the print section.
  • Now, click on the drop-down arrow of the last scaling option and choose Fit Sheet on One Page option.

Use Print Features to Save Excel as PDF Fit into Page

  • You will see that the number of pages reduces to 1.

Use Print Features to Save Excel as PDF Fit into Page

  • After that, select the Save As option.

  • As a result, the Save As dialog box will appear. Choose your desired location to save the PDF file. In our case, we choose the Desktop.
  • Then, click on Save.

  • Finally, open the PDF file.
  • You will see the dataset fitted into a page.

How to Save Excel as PDF Fit to Page

Thus, we can say that our saving method worked perfectly and we are able to save Excel as PDF fit to a page.

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


2. Modifying Page Setup

We will modify the Page Setup option to fit the dataset into a page in this method. The steps of this process are given below:

📌 Steps:

  • First, in the Page Layout tab, click on the Page Setup dialog box launcher.

Modifying Page Setup to Save Excel as PDF Fit into Page

  • A small window titled Page Setup will appear on your device.
  • Now, in the Page tab, choose the Fit to option and keep the value of both boxes 1.
  • Then, click OK to close the box.

Modifying Page Setup to Save Excel as PDF Fit into Page

  • After that, click File > Save As.

  • A dialog box called Save As will appear. Choose your desired location to save the PDF file. In our case, we choose the Desktop.
  • Finally, click on Save.

  • Now, double-click on the file to open.
  • You will see your dataset fitted into a page.

How to Save Excel as PDF Fit to Page

In the end, we can say that our method worked successfully and we are able to save Excel as PDF fit to a page.

Read More: How to Save One Sheet in Excel as PDF (3 Useful Ways)


3. Changing Width in Scale to Fit Group

The Scale to Fit group locates in the Page Layout tab also helps us to fit an Excel datasheet into a page. The procedure to fit a table into a page is given below:

📌 Steps:

  • At first, in the View tab, click on the Page Break View from the Workbook View group.

Change Values in Scale to Fit Group to Save Excel as PDF Fit into Page

  • You will see the dataset is placed on two pages.

Change Values in Scale to Fit Group to Save Excel as PDF Fit into Page

  • After that, in the Page Layout tab, change the Width option Automatic to 1 page in the Scale to Fit group.
  • You will get the whole dataset fit into a single page.

Change Values in Scale to Fit Group to Save Excel as PDF Fit into Page

  • Now, click File > Save As.

  • As a result, the Save As dialog box will appear. Choose your desired location to save the PDF file. In our case, we choose the Desktop.
  • Then, click on Save.

  • At last, double-click on the file to open.
  • You will see the dataset fitted into a page.

How to Save Excel as PDF Fit to Page

Finally, we can say that our method worked effectively and we are able to save Excel as PDF fit to a page.


Similar Readings


4. Adjusting Column Width

Adjusting the column width sometimes helps us to fit our dataset into a page. When we get the headers of the dataset are quite long, but the entities belonging to that column are short, then this method can be the best solution. The process is explained below step by step:

📌 Steps:

  • If we look at our dataset, we will see the headers of columns G and H are long enough compared to their other cell values.
  • To shorter the headers, select the range of cells G4:H4.
  • In the Home tab, select the Wrap Text command from the Alignment group.

Adjusting Column Width to Save Excel as PDF Fit into Page

  • Now, move your mouse cursor to the boundary line between columns G and H. You will see the cursor will convert into a resize icon.

Adjusting Column Width to Save Excel as PDF Fit into Page

  • Then, wild press on the left key of your mouse and drag the resize icon to your left.
  • The column width will be adjusted.

Adjusting Column Width to Save Excel as PDF Fit into Page

  • Similarly, follow the same process for column H.

  • After that, click File > Save As.

  • As a result, the Save As dialog box will appear. Choose your desired location to save the PDF file. In our case, we choose the Desktop.
  • Then, click on Save.

  • Finally, double-click on the file to open.
  • You will see the dataset fitted into a page.

Adjusting Column Width to Save Excel as PDF Fit into Page

Thus, we can say that our method worked successfully and we are able to save Excel as PDF fit to a page.

Read More: Excel VBA: Create Invoice and Save PDF Format (with Quick Steps)


5. Reducing Font Size

Reducing the font size of our dataset is another way to fit the dataset into a page. However, the reduction of font size may decrease the readability of the data to others. The steps of this approach are given as follows:

📌 Steps:

  • At the beginning of this process, select the entire range of cells B4:H25.

  • Now, in the Home tab, click on the Decrease Font Size command from the Font group.

Reducing Font Size to Save Excel as PDF Fit in a Page

  • With every click the font size decrease one by one.
  • After that, fit the column width with the new font size.
  • Then, click File > Save As.

  • As a result, the Save As dialog box will appear. Choose your desired location to save the PDF file. In our case, we choose the Desktop.
  • Next, click on Save.

  • Finally, double-click on the file to open.
  • You will see the dataset fitted into a page.

Reducing Font Size to Save Excel as PDF Fit in a Page

So, we can say that our method worked perfectly, and we are able to save Excel as PDF fit to a page.

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


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to save Excel as PDF fit to page. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo