How to Fit an Excel Sheet in One PDF Page – 8 Simple Methods

The dataset is a Marksheet of 20 students.

Method 1 – Using the Page Setup Feature to Fit an Excel Sheet on One PDF Page

• Go to the File tab.

One Page PDF" width="608" height="172" />

In Print Preview, you will be able to see the number of pages. Here, 2 pages.

One Page PDF" width="700" height="575" />

Step 2: Fitting the Excel Sheet on One Page

One Page PDF" width="700" height="142" />

In the preview, you can see that the dataset fits on one page PDF.

One Page PDF" width="700" height="581" />

In the Save Print Output as dialog box:

This is the output.

Method 2 – Using the Page Break Preview Feature to Fit an Excel Sheet on One Page

Steps:

You will see the Page Break Preview. Here, you will be able to see the number of pages.

• Select and drag the Page Border to the border of your dataset to fit it on one page PDF.

This is the output.

Follow the procedure described in Step 2, Method 1 to save the PDF.

This is the output.

Method 3 – Change Scaling to Fit an Excel Sheet on One Page PDF

Steps:

• Go back to your worksheet.
• Go to the File tab.

One Page PDF" width="608" height="172" />

One Page PDF" width="328" height="736" />

This is the output.

• Follow the procedure described in Step 2,Method 1 to save the PDF.

This is the output.

One Page PDF" width="700" height="582" />

Method 4 – Adjusting Column Width or Row Height to Fit an Excel Sheet on One PDF Page

Consider the dataset below.

Steps:

One Page PDF" width="700" height="581" />

• Go back to your worksheet.
• Adjust the column width.

One Page PDF" width="700" height="587" />

Follow the procedure described in Step 2, Method 1 to save the PDF.

This is the output.

One Page PDF" width="692" height="699" />

Method 5 – Changing Page Orientation to Fit an Excel Sheet on One PDF Page

Steps:

• Go back to your worksheet.
• Select Page Layout.
• Select the dialog box in Page Setup.

One Page PDF" width="700" height="142" />

In the Page Setup dialog box:

One Page PDF" width="641" height="588" />

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

Follow the procedure described in Step 2, Method 1 to save the PDF.

This is the output.

One Page PDF" width="700" height="529" />

Method 6 – Adjusting the Font Size to Fit an Excel Sheet on one page

One Page PDF" width="700" height="478" />

Steps:

• Go back to your worksheet.
• Adjust the Font Size.

One Page PDF" width="700" height="578" />

Follow the procedure described in Step 2, Method 1 to save the PDF.

This is the output.

Method 7 – Change the Page Margins to Fit an Excel Sheet on One Page PDF

Steps:

One Page PDF" width="653" height="170" />

One Page PDF" width="326" height="593" />

One Page PDF" width="638" height="587" />

In the Print Preview you will see that the PDF fits on one page.

One Page PDF" width="700" height="577" />

Follow the procedure described in Step 2, Method 1 to save the PDF.

This is the output.

Method 8 – Hiding Rows/Columns to Fit an Excel Worksheet on One PDF Page

Steps:

One Page PDF" width="700" height="579" />

This is the output.

One Page PDF" width="700" height="522" />

One Page PDF" width="700" height="578" />

This is the output.

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

Steps:

• Select the data.

Follow the procedure described in Step 2, Method 1 to save the PDF.

This is the output.

Download Practice Workbook

Related Articles

• [Solved!] Print Scale to Fit Not Working in Excel
• Print Full Page of Excel Sheet in A4 Size
• How to Add Legal Paper Size in Excel
• Why Is My Excel Sheet Printing So Small
• How to Add A3 Paper Size in Excel

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

Leave a reply Cancel reply

• 5 Excel Formulas Every Data Analyst Should Know
• 5 Essential Excel Functions for Data Analysis
• Excel Power Pivot Measures – 5 Examples
• Power Pivot Formulas (2 Suitable Examples)
• Excel Data for Analysis (Free Download 11 Suitable Datasets)
• Excel Sample Data (Free Download 13 Sample Datasets)

Posts from: Print Scale Excel

• [Solved!] Excel Scaling Issues (2 Easy Methods)
• [Solved!] Print Scale to Fit Not Working in Excel
• How to Add Paper Size in Excel (4 Easy Ways)
• How to Print a Full Page of an Excel Sheet in A4 Size (5 Methods)
• How to Fit to Page in Excel – 3 Methods
• How to Fit Excel Sheet on One Page in Word (3 Simple Ways)
• How to Stretch Excel Spreadsheet to Full Page Print (5 Easy Ways)
• How to Fit All Columns on One Page in Excel (6 Methods)
• How to Add Legal Paper Size in Excel
• Excel Fit to Page Scale/Preview Looks Small (5 Suitable Solutions)

ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.