✦Template Printable Ideas Insights

Print Multi-Sheet Excel to PDF

By

When working with extensive Excel data, there may be instances where you need to print multiple sheets to a single PDF. This can be particularly useful for record-keeping, sharing, or archiving purposes. Unfortunately, Excel doesn't provide a built-in feature to print multiple sheets to a single PDF. However, there are workarounds using third-party tools and add-ins. Let's explore two easy methods to achieve this.

Before proceeding, ensure that you have all the necessary sheets set up and the data is perfectly formatted. This will ensure a seamless PDF creation process.

Using a Free Third-Party Add-In (PDFmyXLS)

PDFmyXLS is a free Excel add-in that allows you to merge multiple sheets into a single PDF.

how to print multiple sheets in excel on one page
how to print multiple sheets in excel on one page
Copy Data From One Sheet to Another in Excel
Copy Data From One Sheet to Another in Excel
How to Print Multiple Sheets on One sheet in Excel by learning center In Urdu/Hindi
How to Print Multiple Sheets on One sheet in Excel by learning center In Urdu/Hindi

First, download and install the add-in from the official website. Once installed, you'll see a new tab named 'PDF' in your Excel ribbon.

Merging Multiple Sheets to a Single PDF

To merge sheets, follow these steps:

How to convert excel files with multiple sheets to pdf (not printed to pdf)
How to convert excel files with multiple sheets to pdf (not printed to pdf)
[FREE] 7 Quick Ways to Convert Excel to PDF & PDF to Excel
[FREE] 7 Quick Ways to Convert Excel to PDF & PDF to Excel
Combine Data from Multiple worksheets into ONE sheets | Excel Tutorial
Combine Data from Multiple worksheets into ONE sheets | Excel Tutorial

  1. Select the sheets you want to merge from the 'Worksheet' list.
  2. Click on 'Merge and Print Selected Worksheets'.
  3. Choose the PDF print options like margin size, paper size, and orientation.
  4. Click 'OK' to proceed with the PDF creation.

Once created, you can save the PDF to your desired location or print it directly.

[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
how to create a master sheet from multiple sheets in excel
how to create a master sheet from multiple sheets in excel
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet
Bookkeeping Spreadsheets, The 5 Best Websites to Download Free Excel Templates 💵
Bookkeeping Spreadsheets, The 5 Best Websites to Download Free Excel Templates 💵
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step

Using PDFmyXLS with Print Areas

If your sheets have non-contiguous data, you can use print areas to include only the relevant ranges in your PDF.

To set a print area, follow these steps:

Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
How to Merge Microsoft Excel Files and Sheets
How to Merge Microsoft Excel Files and Sheets
How to Duplicate a Worksheet in Excel
How to Duplicate a Worksheet in Excel
  1. Select the data range you want to print.
  2. Go to 'Page Layout' tab and click on 'Print Area'.
  3. Select 'Set Print Area'.
  4. Now, use the 'Merge and Print Selected Worksheets' option in the 'PDF' tab to create the PDF.

Only the selected print areas will be included in the final PDF.

Using Google Sheets and Google Drive

Another method involves converting your Excel file to a Google Sheet and using Google Drive to print to PDF.

First, upload your Excel file to Google Drive, then open it. Select all the sheets you want to include in the PDF, right-click, and choose 'Print'.

Printing to PDF

In the print dialog box, select 'Save as PDF' instead of your printer.Choose your preferred PDF settings and click 'Save'.

Your multiple sheets will now be combined into a single PDF, accessible in your Google Drive.

Managing Large Files on Google Drive

If you're dealing with large files, consider splitting your data into smaller, manageable sheets before merging them into a PDF. This can prevent performance issues and ensure a smoother process.

Google Drive also offers a 'Compress' option to reduce file sizes. Upload your PDF, right-click, and choose 'Compress'. Google Drive will create a compressed version, saving storage space without compromising on quality.

Now that you've learned how to print multiple sheets to a single PDF, you can streamline your workflow and create more efficient records. Whether you're using a third-party add-in or Google Drive, these methods can help you consolidate your data for better organization and shareability. Happy printing!