See all How-To Articles

Save Multiple Sheets as PDF in Excel & Google Sheets

This tutorial will show how to save multiple sheets as PDF in Excel and Google Sheets.

 

pdf files with multiple worksheets

 

Export Multiple Sheets as PDF

By default, when you save an Excel file as a PDF, only the first worksheet is saved. However, you can select multiple sheets to save as PDF. Suppose you have the following Excel file with three sheets (Sheet 1, Sheet 2, and Sheet 3) with the same data.

 

save multiple sheets as pdf initial data

 

  1. Select all the worksheets you want to save as PDF. Hold down the CTRL key and click on the tabs of each sheet you want to save (Sheet 1 and Sheet 2).

 

select multiple sheets

 

  1. In the Ribbon, select File > Export

 

save excel as pdf export

 

  1. Select Create PDF/XPS Document and click Create PDF/XPS.

 

save excel as pdf export 2

 

  1. In the Search window, enter (1) a name and (2) a destination for the file, and then (3) click Publish.
    By default, the new PDF file has the same name and destination as the original Excel file.

 

save excel as pdf export 3

 

As a result, a PDF file is saved with all the worksheets (Sheet 1 and Sheet 2) selected in the Excel file. Each sheet starts on a new page in the PDF file.

 

pdf files with multiple worksheets

 

Save a PDF Copy

Another way to achieve the same result is to change the file type when saving.

  1. Select all the worksheets you want to save as PDF. Hold down the CTRL key and click on the tabs of each sheet you want to save (for example, Sheet 1 and Sheet 2).

 

select multiple sheets

 

  1. In the Ribbon, select File > Save Copy (Save As).

 

save excel as pdf file save

 

  1. Select the PDF (*.pdf) file type and click Save.

 

save excel as pdf file save 2

 

The result is the same as in the previous method: A new PDF file is created from the Excel worksheets.

Save Multiple Google Sheets as PDF

Like an Excel workbook, a Google Sheets file can also be saved as a PDF.

  1. Go to File > Download > PDF Document (.pdf) in the Menu.

 

google sheets save as pdf

 

  1. In the Print window, (1) under Export, select Workbook. (2) Tick Sheet 1 and Sheet 2 for the selection, and (3) click Apply. Finally (4) click Export.

 

google sheets save multiple sheets as pdf

 

A new PDF file with the selected worksheets from the Google Sheets file is now saved under the same name in the Downloads folder.