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

The sample dataset contains information on 21 employees in the range of cells B4:H25. Saving this dataset as a PDF will break the table over two pages.

Method 1 – Using the Print Option to Fit Excel Dataset into a Page and Then Saving as PDF

Use Print Features to Save Excel as PDF Fit into Page

Use Print Features to Save Excel as PDF Fit into Page

How to Save Excel as PDF Fit to Page

Method 2 – Saving Excel as PDF After Modifying Page Setup

Steps:

Modifying Page Setup to Save Excel as PDF Fit into Page

Modifying Page Setup to Save Excel as PDF Fit into Page

How to Save Excel as PDF Fit to Page

Method 3 – Changing the Width in Scale to Fit Group and Saving as PDF Afterwards

Steps:

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

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

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

How to Save Excel as PDF Fit to Page

Method 4 – Adjusting Column Width to Save Excel as PDF Fit to Page

Steps:

Adjusting Column Width to Save Excel as PDF Fit into Page

Adjusting Column Width to Save Excel as PDF Fit into Page

Adjusting Column Width to Save Excel as PDF Fit into Page

Adjusting Column Width to Save Excel as PDF Fit into Page

Method 5 – Saving Excel as PDF Fit to Page by Reducing Font Size

Steps:

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

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

Download Practice Workbook

Related Articles

Save Saved Removed 0 Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that. Read Full Bio