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

 

 

 

Related Posts

If Cell is This Value or That Value

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of logical test. If you want to see if a cell is A or B, and if one of ...

If Value is Greater Than A Certain Value
If Value is Greater Than A Certain Value 1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the logical test result. If you want to see if a value in one cell is greater than a specific value, ...

If Cell is Not Blank
If Cell is Not Blank 6

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

VBA Macro For VLOOKUP From Another Sheet
vba macro for vlookup from another sheet1

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you how to use VBA code to vlookup data ...

If Cell is Blank
If Cell is Blank_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

If Cell Equals Certain Text String
If cell equals certain text_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if cell equals a certain text string like “Win”, you ...

If Cell Contains Either Text1 or Text2
If cell contains text1 or text2_1

IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to see if cell contains certain substring1 like “abc” or substring2 like “def”, and returns true ...

If Cell Contains Certain Text OR Equals Certain Text

IF cell equals certain text IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to test values to see if they equal certain text like ...

VLOOKUP From Another Sheet Not Working
vlookup from another sheet not working3

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you reasons why your VLOOKUP formula is not working ...

If Cell Begins with One of Three Supplied Characters
If Cell Begins with One of Three Supplied Characters

If you want to test values to see if they begin with some given specific characters like “x”, ”y”, or “z”, you can create a formula with COUNTIF and SUM functions to return results. EXAMPLE You can see “TRUE” or ...

Sidebar