✦Template Printable Ideas Insights

How to Print All Sheets in Excel to PDF

By

Are you looking for a way to save all your Excel sheets as PDFs simultaneously? While Excel doesn't have a built-in feature to print all sheets at once to PDF, there are workarounds to accomplish this task efficiently. Let's explore two popular methods to convert multiple Excel sheets into PDFs in a single go.

Before we dive into the methods, ensure you have the appropriate software and permissions on your computer. For both methods, you'll need Microsoft Excel and a PDF printer driver installed. If you don't have one, you can use free software like CutePDF or Adobe Acrobat's Print Driver.

Method 1: Using Excel's FILE > PRINT Options

This method is suitable for workbooks with a limited number of sheets. It involves manually selecting the sheets and printing them as PDFs using the 'Print' dialog box.

Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
Convert Excel sheet to PDF
Convert Excel sheet to PDF

To begin, follow these steps:

Step 1: Open your Excel workbook

Open the Excel file containing the sheets you want to convert to PDF.

an excel spreadsheet in the office window
an excel spreadsheet in the office window
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Your Custom Budget Spreadsheet Solution
Your Custom Budget Spreadsheet Solution

Step 2: Choose the sheets for printing

Click on the 'Sheet1' tab at the bottom of the window, then press and hold the 'Ctrl' button on your keyboard. Next, click on each sheet you want to print, or use 'Shift' + 'Ctrl' to select multiple consecutive sheets.

Step 3: Print the selected sheets as PDF

With the sheets selected, go to the 'File' menu and click on 'Print'. In the 'Print' dialog box, choose 'Microsoft Print to PDF' from the 'Printer' dropdown menu. You can also customize the layout, margins, and other settings here. Once you're satisfied, click 'Print'.

Repeat these steps for each workbook containing the sheets you want to convert to PDF.

7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
how to print large excel sheet in one page
how to print large excel sheet in one page
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
the top 21 excel formulas poster is shown in green and orange, with instructions for each
the top 21 excel formulas poster is shown in green and orange, with instructions for each
Copy Data From One Sheet to Another in Excel
Copy Data From One Sheet to Another in Excel

Method 2: Using a VBA Script (Recommended for large workbooks)

If your workbook has numerous sheets, using the first method can be time-consuming. A more efficient way is to use a VBA (Visual Basic for Applications) script. This method automates the process, saving you time and effort.

Here's a simple VBA script that prints all sheets in an Excel workbook as separate PDFs:

Step 1: Enable Developer Tab (if not already enabled)

To access the VBA editor, you need to enable the 'Developer' tab in Excel. Right-click on the Ribbon and select 'Customize the Ribbon', then check the box next to 'Developer'.

Basic Excel Formulas
Basic Excel Formulas
How to create a list of all worksheet names from a workbook?
How to create a list of all worksheet names from a workbook?
Boost Productivity With 141 Free Sheets
Boost Productivity With 141 Free Sheets

Step 2: Enter and run the VBA script

Open the VBA editor by pressing 'Alt + F11'. In the editor, go to 'Insert' > 'Module' to create a new module. Copy and paste the following script into the module:

```vba Sub PrintAllSheetsAsPDF() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.ExportAsFixedFormat Type:=xlTypePDF, filename:=ThisWorkbook.Path & "\" & ws.Name & ".pdf", OpenFileName:=False Next ws End Sub ```

Press 'F5' to run the script. The script will iterate through each sheet in the active workbook and print it as a separate PDF in the same folder as the Excel file.

Conclusion and Next Steps

Both methods have their advantages depending on your specific needs. The first method is suitable for small workbooks or when you only need to print a few sheets. The VBA script, on the other hand, is ideal for workbooks with numerous sheets and when you need to convert them frequently.

After mastering these methods, you can explore more advanced features like combining multiple PDFs, securing them with passwords, or optimizing them for better print quality. Happy printing!