How to Export Worksheet/Workbook as PDF Type in Excel

Sometimes we need to export worksheet or workbook from excel file to PDF type then we can insert them into PPT or Word for presentation or reporting or other purpose conveniently. In previous article, we have introduced the way to export chart into PDF type. We will introduce you the way to export worksheet or workbook into PDF in this article. Actually, the two ways are similar. We can through Save as function to save worksheet to PDF type easily.

Precondition:

Create a table in sheet1.

How to Export WorksheetWorkbook as PDF Type 1

Method: Export Worksheet/Workbook as PDF Type by Save As


Step 1: Select the range you want to export as PDF. Refer to above screenshot select A1:C14.

Step 2: Click File in ribbon.

How to Export WorksheetWorkbook as PDF Type 2

Then select Sava As.

How to Export WorksheetWorkbook as PDF Type 3

Step 3: You can click This PC or Browse to select save chart location. If you want save it in your computer, select anyone is ok.

How to Export WorksheetWorkbook as PDF Type 4

Step 4: After choosing save PDF file location, enter File name as Sheet1, in Save as type dropdown list select PDF. Then click Save.

How to Export WorksheetWorkbook as PDF Type 5

How to Export WorksheetWorkbook as PDF Type 6

Step 5: After saving, Sheet1.pdf pops up in the front of screen automatically.

How to Export WorksheetWorkbook as PDF Type 7

Step 6: Close Sheet1.pdf file. Enter your selected location for saving PDF file, I save it on desktop. Check exported file in desktop. Verify that sheet1.pdf icon displays properly. You can double click on it to open sheet1.

How to Export WorksheetWorkbook as PDF Type 8

Comments:

1: If you ignore step1 (don’t select any range on current worksheet), the entire worksheet will be exported and displayed in exported PDF file. See screenshot below.

How to Export WorksheetWorkbook as PDF Type 9

  1. If there are multiple worksheets exist in one workbook, only the opened one is exported.
  2. If you want to export all worksheets or some worksheets, you can hold on Ctrl key and select the worksheets you want to export, then repeat above steps to do export. In this case worksheets will be exported into one PDF file but one worksheet displays in one page.

Press Ctrl key to select worksheets:

How to Export WorksheetWorkbook as PDF Type 10

One worksheet one page:

How to Export WorksheetWorkbook as PDF Type 11

 

 

 

Sidebar