How to Fit Excel Sheet on One Page PDF (8 Simple Ways)

Get FREE Advanced Excel Exercises with Solutions!

Whenever working with Excel, making PDFs from the Excel sheet is needed sometimes. The main objective of this article is to explain how to fit Excel sheet on one page PDF.

To explain this article, I have taken the following dataset which is the Marksheet of 20 students. Here, I will show you how to fit Excel sheet on one page PDF in 8 easy methods.


1. Using Page Setup Feature to Fit Excel Sheet on One Page PDF

In this method, I will explain how to fit an Excel sheet on one page PDF using the Page Setup feature.

Let’s see the steps.


Step-01: Checking If It Fits on One Page

In this step, I will show you how you can check if an Excel sheet fits on one page PDF.

  • Firstly, go to the File tab from the Ribbon.

Using Page Setup Feature to Fit Excel Sheet on One Page PDF

  • Secondly, select the Print option.

Now, in the Print Preview, you will be able to see how many pages it will take. Here, we can see that my dataset will take 2 pages.

Using Page Setup Feature to Fit Excel Sheet on One Page PDF

Finally, click the back option to go back to your worksheet. So that, you can perform further operations.


Step-02: Fitting Excel Sheet on One Page

In this step, I will show you how you can fit an Excel sheet into one page PDF.

  • Firstly, go to the Page Layout tab.
  • Secondly, select the dialog box option from Page Setup.

Using Page Setup Feature to Fit Excel Sheet on One Page PDF

Now, you will see the dialog box named Page Setup.

  • Thirdly, select Fit to 1 page(s) and wide by 1 tall.
  • After that, select Print Preview.

Here, in the preview, you can see that the dataset fits in one page PDF.

  • Now, select Microsoft print to PDF from Printer.
  • After that, select Print to save your Excel sheet as a PDF.

Using Page Setup Feature to Fit Excel Sheet on One Page PDF

Now, a dialog box named Save Print Output as will appear.

  • Firstly, type the File name as you want.
  • Secondly, select Save.

Here, in the following image, you can see my final PDF opened in my PDF viewer. I have included a zoomed image here for a better view but in the bar, you can clearly see that it is a one page PDF.

Read More: How to Fit Excel Sheet on One Page in Word 


2. Using Page Break Preview Feature to Fit Excel Sheet on One Page

In this method, I will show you how to fit an Excel sheet on one page PDF using Page Break Preview.

Let’s see the steps.

Steps:

  • Firstly, go to the View tab.
  • Secondly, select Page Break Preview.

Now, you will see the Page Break Preview. Here, you will be able to see how many pages your PDF will take.

Employing Page Break Preview Feature

  • After that, select and drag the Page Border to the border of your dataset to fit it in one page PDF.

Now, in the following image, you can see that my whole dataset fits on Page 1.

Employing Page Break Preview Feature

  • Next, go to the Print Preview. Here, you will see the PDF will take 1 page.
  • After that, select Microsoft print to PDF from Printer.
  • Finally, select Print to save your Excel sheet as a PDF.

Here, follow the procedure from Step-02 of Method-1 to save the PDF.

Now, in the following image, you can see my final PDF opened in my PDF viewer. I have included a zoomed image here for a better view but in the bar, you can clearly see that it is a one page PDF.

Read More: How to Fit to Page in Excel 


3. Change Scaling to Fit Excel Sheet on One Page PDF

In this method, I will explain how to fit Excel Sheet on one page PDF by changing the Scaling.

Let’s see the steps.

Steps: 

  • Firstly, check the Print Preview by following the procedure of Step-01 from Method-1. Here, you can see that the PDF will take 2 pages.

Now, go back to your worksheet to do further operations.

  • Firstly, go to the File tab.

Changing Scaling to Fit Excel Sheet on One Page PDF

  • Secondly, select Print.

  • Thirdly, select the Scaling option from Settings.

Here, you will see a drop-down menu.

  • Next, select Fit Sheet on One Page.

Changing Scaling to Fit Excel Sheet on One Page PDF

Now, in the Print Preview, you will see that the PDF fits on one page.

  • After that, select Microsoft print to PDF from Printer.
  • Finally, select Print to save your Excel sheet as a PDF.

Here, follow the procedure from Step-02 of Method-1 to save the PDF.

Now, in the following image, you can see my final PDF opened in my PDF viewer. I have included a zoomed image here for a better view but in the bar, you can clearly see that it is a one page PDF.

Changing Scaling to Fit Excel Sheet on One Page PDF

Read More: How to Change the Printing Scale So All Columns Will Print on a Single Page


4. Adjusting Column Width or Row Height to Fit Excel Sheet on One Page PDF

In this method, I will explain how to fit Excel sheet on one page PDF by adjusting column width or row height. To explain this method I will use the following dataset.

Let’s see the steps.

Steps:

  • Firstly, check the Print Preview by following the procedure of Step-01 from Method-1. Here, you can see that the PDF will take 2 pages.

Adjusting Column Width or Row Height to Fit Excel Sheet on One Page PDF

Now, go back to your worksheet to do further operations.

  • After that, adjust the column width as you need. Here, in the following image, you can see that I have changed my column width according to my need.

  • Next, go to the print preview. Here, you will see the PDF will take 1 page.
  • After that, select Microsoft print to PDF from Printer.
  • Finally, select Print to save your Excel sheet as a PDF.

Adjusting Column Width or Row Height to Fit Excel Sheet on One Page PDF

Here, follow the procedure from Step-02 of Method-1 to save the PDF.

Now, in the following image, you can see my final PDF opened in my PDF viewer. I have included a zoomed image here for a better view but in the bar, you can clearly see that it is a one page PDF.

Adjusting Column Width or Row Height to Fit Excel Sheet on One Page PDF

Read More: How to Fit All Columns on One Page in Excel


5. Changing Page Orientation for Fitting Excel Sheet on One Page PDF

In this method, I will explain how to fit Excel sheet on one page PDF by changing Page Orientation.

Let’s see the steps.

Steps:

  • Firstly, check the Print Preview by following the procedure of Step-01 from Method-1. Here, you can see that the PDF will take 2 pages.

Now, go back to your worksheet to do further operations.

  • Here, go to the Page Layout tab.
  • Next, select the dialog box option from Page Setup.

Changing Page Orientation for Fitting Excel Sheet on One Page PDF

Here, the Page Setup dialog box will appear.

  • Firstly, select Landscape as Orientation.
  • Secondly, select Fit to 1 page(s) and wide by 1 tall.
  • Thirdly, select Print Preview.

Changing Page Orientation for Fitting Excel Sheet on One Page PDF

Now, in the Print Preview, you will see that the PDF fits on one page.

  • After that, select Microsoft print to PDF from Printer.
  • Finally, select Print to save your Excel sheet as a PDF.

Here, follow the procedure from Step-02 of Method-1 to save the PDF.

Now, in the following image, you can see my final PDF opened in my PDF viewer. I have included a zoomed image here for a better view but in the bar, you can clearly see that it is a one page PDF.

Changing Page Orientation for Fitting Excel Sheet on One Page PDF

Read More: How to Stretch Excel Spreadsheet to Full Page Print 


6. Adjusting the Font Size to Fit Excel Sheet

In this method, I will explain how to fit Excel sheet on one page PDF by adjusting the font size. To explain this example I have taken the following dataset.

Adjusting the Font Size to Fit Excel Sheet on One Page PDF

Let’s see the steps.

Steps:

  • Firstly, check the Print Preview by following the procedure of Step-01 from Method-1. Here, you can see that the PDF will take 2 pages.

Now, go back to your worksheet to do further operations.

  • After that, adjust the Font Size as you need. Here, in the following image, you can see that I have changed my Font Size according to my need.

  • Next, go to the Print Preview. Here, you will see the PDF will take 1 page.
  • After that, select Microsoft print to PDF from Printer.
  • Finally, select Print to save your Excel sheet as a PDF.

Adjusting the Font Size to Fit Excel Sheet on One Page PDF

Here, follow the procedure from Step-02 of Method-1 to save the PDF.

Now, in the following image, you can see my final PDF opened in my PDF viewer. I have included a zoomed image here for a better view but in the bar, you can clearly see that it is a one page PDF.

Read More: How to Add Paper Size in Excel 


7. Change Page Margins to Fit Excel Sheet on One Page PDF

In this method, I will explain how to fit Excel sheet on one page PDF by changing the Page Margins. To explain this example I have taken the following dataset.

Let’s see the steps.

Steps:

  • Firstly, check the Print Preview by following the procedure of Step-01 from Method-1. Here, you can see that the PDF will take 2 pages.

Now, go back to your worksheet to do further operations.

  • Here, go to Page Layout tab.
  • After that, select Margins.

Changing the Page Margins to Fit Excel Sheet on One Page PDF

Here, a drop-down menu will appear.

  • Now, select Custom Margins from the drop-down menu.

Changing the Page Margins to Fit Excel Sheet on One Page PDF

Now, a dialog box will appear.

  • After that, set the Margins as you want. Here, I selected all the Margins as 0.

  • Finally, select Print Preview.

Changing the Page Margins to Fit Excel Sheet on One Page PDF

Now, in the Print Preview you will see that the PDF fits on one page.

  • After that, select Microsoft print to PDF from Printer.
  • Finally, select Print to save your Excel sheet as a PDF.

Changing the Page Margins to Fit Excel Sheet on One Page PDF

Here, follow the procedure from Step-02 of Method-1 to save the PDF.

Now, in the following image, you can see my final PDF opened in my PDF viewer. I have included a zoomed image here for a better view but in the bar, you can clearly see that it is a one page PDF.

Read More: How to Adjust Page Size for Printing in Excel 


8. Hiding Row/Column to Fit Excel Worksheet on One Page PDF

In this method, I will explain how to fit Excel sheet on one page PDF by hiding row/column.

Let’s see the steps.

Steps:

  • Firstly, check the Print Preview by following the procedure of Step-01 from Method-1. Here, you can see that the PDF will take 2 pages.

Hiding Row/ Column to Fit Excel Sheet on One Page PDF

Now, go back to your worksheet to do further operations. In my dataset, History, Statistics, and Art are optional subjects. I do not need these columns on my PDF. I also do not need the Total column. So, I will hide these columns. Let’s see how you can hide columns in Excel.

  • Firstly, Right-click on the column that you want to hide.
  • Secondly, select Hide.

Here, in the following image, you can see that I have hidden column H which was the History column in my dataset.

Hiding Row/ Column to Fit Excel Sheet on One Page PDF

  • Now, in the same way, hide all the columns that you don’t need. Here, I have hidden columns H to K.

  • Next, go to the print preview. Here, you will see the PDF will take 1 page.
  • After that, select Microsoft print to PDF from Printer.
  • Finally, select Print to save your Excel sheet as a PDF.

Hiding Row/ Column to Fit Excel Sheet on One Page PDF

Now, follow the procedure from Step-02 of Method-1 to save the PDF.

Here, in the following image, you can see my final PDF opened in my PDF viewer. I have included a zoomed image here for a better view but in the bar, you can clearly see that it is a one page PDF.

Read More: Excel Fit to Page Scale/Preview Looks Small


How to Fit Only Selected Data from an Excel Sheet onto PDF

In this method, I will explain how to fit selected data from an Excel sheet into a PDF.

Let’s see the steps.

Steps:

  • Firstly, select the data that you want to make a PDF of.

How to Fit Only Selected Data from an Excel Sheet on PDF

  • Secondly, go to the File tab.

  • Thirdly, select Print.

How to Fit Only Selected Data from an Excel Sheet on PDF

  • After that, click on the marked drop-down option.

Now, you will see a drop-down menu will appear.

  • Next, select Print Selection from the drop-down menu.

How to Fit Only Selected Data from an Excel Sheet on PDF

  • After that, select Microsoft print to PDF from Printer.
  • Finally, select Print to save your Excel sheet as a PDF.

Here, follow the procedure from Step-02 of Method-1 to save the PDF.

Now, in the following image, you can see my final PDF opened in my PDF viewer. I have included a zoomed image here for a better view but in the bar, you can clearly see that it is a one page PDF.


Download Practice Workbook


Conclusion

To conclude, in this article I tried to explain how to fit Excel sheet on one page PDF. Here, I covered 8 different methods of doing it. I hope, this article was helpful for you. If you have any questions, feel free to let me know in the comment section below.


Related Articles

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mashhura Jahan
Mashhura Jahan

Mashhura Jahan, BSc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology, invested 1.5 years at ExcelDemy. In roles like Excel & VBA Content Developer, Excel Charts, and Dashboard course trainer, she wrote 90+ articles. She was previously part of the forum support team and a junior software analyst on the Excel Add-in project. With interests spanning Excel, VBA, Power Query, Python, Data Science, and Software Development, Mashhura brings a diverse skill set to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo