How to Insert PDF into Excel
A free Office suite fully compatible with Microsoft Office
Sometimes it is hard for a beginner to know how to insert a PDF into an excel sheet. This article is set to help you know how to merge PDF files into excel. It is quite easy if you follow the following steps carefully.
Remember, the excel sheet is one of the key players when carrying out data analysis. This is an important tool for accounts and several other professionals. You may be trying to issue invoices using your excel workbook and do not know how to do it. We will help you to learn how to insert PDF into Excel using three outstanding methods of inserting PDF into excel, and steps to follow when doing it.
There are simple methods of inserting PDF files into Excel
Method 1: Inserting PDF Files into Excel Sheets as an Object
As we said, there are several ways of doing this, but the first way is to insert your PDF file as an object. The Excel workbook can integrate with many tools that are used when performing different tasks such as calculations and graphics. With excel 2010, 2013, 2016, and Excel 365 you can easily insert a PDF file into an Excel spreadsheet or excel workbook. These versions of Excel have essential tools that can help you to insert your PDF into excel using mac or windows.
Steps to follow when inserting PDF files in Excel as an object
Step 1: Open the Excel spreadsheet and tap on the ‘Insert’ menu.
Step 2: Next is to select ‘Object’ on your drop menu.
Step 3: In the pop-up dialogue box, select ‘Create from File’ this will enable you to browse the folders and select the PDF file you want to use.
Step 4: To insert your selected PDF file into the Excel spreadsheet click ‘OK’
At this point, you can insert the selected PDF file as an icon that can be clicked for the file to open. But to apply this procedure you need to ‘Display as icon’ then checkbox by clicking ‘Object’ windows and then press the ‘OK’ button.
Method 2: Inserting the PDF File into Excel through a Hyperlink
In this method, you can embed the PDF file into the Excel worksheet using the ‘Picture’ tool. This tool enables you to easily embed or insert a PDF file into an Excel sheet. You can embed your picture into Excel and link it to a PDF.
Step 1: Open the prepared excel sheet in your excel and then hit the ‘Insert’ button.
Step 2: To insert your images into Excel, you need to click ‘Pictures’ in the secondary toolbar.
Step 3: Right-click on the picture to choose 'link' in the pop-up menu.
Step 4: At this final step you need to locate to select the PDF file to link it to Excel.
Method 3: Insert the PDF file in Excel after Converting it into a Picture.
You can convert your PDF file to Excel format and then, import the converted PDF content into Excel.
Step 1: After launching your Microsoft Excel, click the ‘Insert’ tab.
Step 2: Click the “Pictures” then click “This device” to select the converted image.
This article gives three ways how to insert PDFs into Excel and the steps to follow when inserting them. This article has described three general methods to follow when inserting PDF files into an Excel sheet. While to learn more about it, you can follow the WPS academy. You can use the internet to look online/mac to know more about this.
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences