Save an Excel Workbook (.xlsx) or Google Sheet as a PDF

This tutorial demonstrates how to save an Excel workbook or Google spreadsheet as a PDF.

 

 

Save Excel File as PDF

Save by Exporting

Say you have the following data in an Excel file (.xlsx) and want to export and save it as a PDF.

 

 

1. In the Ribbon, go to File > Export.

 

 

2. Select Create PDF/XPS Document on the left and click Create PDF/XPS.

 

 

3. In the browser window, enter a name and destination for the file. Then click Publish. By default, the PDF file will have the same name and destination as the original Excel file.

 

 

Finally, a new PDF file is saved from the Excel file. By default, Excel will export the current sheet only.

 

 

Save a Copy

Another option to achieve the same result is to change the file type while saving.

1. In the Ribbon, go to File > Save a Copy (Save as).

 

 

2. Choose file type PDF (*.pdf) and click Save.

 

 

The result is the same as with the previous approach: A new PDF file is saved from the Excel worksheet.

Note: You can also save an Excel file as a PDF using VBA code.

Save Google Sheets File as PDF

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

1. In the Menu, go to File > Download > PDF document (.pdf).

 

 

2. In the Print window, change Paper size to Letter and Page orientation to Portrait. Then click Export.

 

 

A PDF file with the Google Sheets file’s data is now saved with the same name in the Downloads folder.