How to merge multiple sheets into 1 PDF file in Excel 2013

When using Office 2007 version and below when you want to convert into a PDF file, you add Add-On but now with Office 2013 with just a few simple steps, you can combine multiple sheets in Excel into one PDF file.

Step 1: Open the Excel file containing the data to merge. For example, there are 3 sheets 1, 2, 3.

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 1

Step 2: Right-click on any one Sheet and select Select All Sheets .

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 2

Step 3: On the card File -> Save As .

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 3

Step 4: A dialog box appears and select Browser to select a folder to save the file.

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 4

Step 5: A dialog box appears -> name the file, under Save as Type -> PDF . Finally, click Save .

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 5

The result after merging 3 sheets into 1 PDF file:

How to merge multiple sheets into 1 PDF file in Excel 2013 Picture 6

Good luck!

3.8 ★ | 6 Vote

May be interested

  • How to insert math formulas in ExcelPhoto of How to insert math formulas in Excel
    in the learning process, you often use ms excel to calculate and process data. because of some requirements that you need to insert mathematical formulas into excel, but you do not know how to manipulate.
  • Instructions to use the Replace feature to reverse position words in WordPhoto of Instructions to use the Replace feature to reverse position words in Word
    the replace feature in word you often know for the word substitution function commonly used to search and replace words in word. but in addition to the functions that you often use, replace also helps you reverse the position of words in word.
  • ISNA function in ExcelPhoto of ISNA function in Excel
    using excel documents shared from friends or on the internet, you sometimes come across isna () combined with other functions like vlookup () and if (). you wonder why they use isna () function so?
  • Instructions on how to draw organizational structure diagram in WordPhoto of Instructions on how to draw organizational structure diagram in Word
    to draw an organization chart in word you can use one of two ways: using smartart and using the shapes tool. using smartart will help you draw an organization chart faster than using the shapes tool.
  • How to write vertically, rotate text vertically in WordPhoto of How to write vertically, rotate text vertically in Word
    according to some requirements, you need to write vertical letters in word, but you do not know how to write vertical letters? to be able to write vertically in word, there are many ways, you can refer to the ways guided in this article.
  • How to delete the underlined red mark in WordPhoto of How to delete the underlined red mark in Word
    the red, blue lines under the words in a word document are features to detect spelling and grammatical errors. but this feature does not apply to vietnamese, so when you type vietnamese with diacritics, a red dot will appear.