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.
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 the Print Option to Fit Excel Dataset into a Page and Then Saving as PDF
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.
- You will see that the number of pages reduces to 1.
- 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.
Thus, we can say that our saving method worked perfectly and we are able to save Excel as PDF fit to a page.
2. Saving Excel as PDF After 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.
- 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.
- 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.
In the end, we can say that our method worked successfully and we are able to save Excel as PDF fit to a page.
3. Changing the Width in Scale to Fit Group and Saving as PDF Afterwards
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.
- You will see the dataset is placed on two pages.
- 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.
- 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.
Finally, we can say that our method worked effectively and we are able to save Excel as PDF fit to a page.
4. Adjusting Column Width to Save Excel as PDF Fit to Page
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.
- 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.
- Then, wild press on the left key of your mouse and drag the resize icon to your left.
- The column width will be adjusted.
- 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.
Thus, we can say that our method worked successfully and we are able to save Excel as PDF fit to a page.
5. Saving Excel as PDF Fit to Page by 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.
- 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.
So, we can say that our method worked perfectly, and we are able to save Excel as PDF fit to a page.
Download Practice Workbook
Download this practice workbook for practice and output files while you are reading this article.
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!
