How to insert a pdf into excel

Sometimes you may have a need to embed a PDF file within the Excel workbook. This could be the case when you are creating a catalog and want to embed product specific PDFs.

In this tutorial, you’ll learn how to insert a PDF file in an Excel Worksheet.

This Tutorial Covers:

How to Embed a PDF File in an Excel Worksheet

Here are the steps to embed a PDF File in Excel:

  • Go to Insert tab and click on the Object icon in the Text group. This will open the Object dialog box.
  • In the Object dialog box, select the ‘Create New’ tab and the select ‘Adobe Acrobat Document’ from the list. Note that you need to have Adobe Reader installed on your system for Adobe object to appear in the list.How to insert a pdf into excel
  • Check the option – ‘Display as icon’.
  • Click OK.
  • Select the PDF file that you want to embed and click on Open.

These steps would insert a PDF file in the worksheet.

As soon as the PDF is inserted in the worksheet, it also gets opened by default. You can close the PDF file and continue to work with Excel.

The PDF icon inserted using the above steps is an object (just like charts or shapes) and you can resize it and place it anywhere in the worksheet.

How to insert a pdf into excel

To insert multiple PDFs, follow the same steps (as shown above).

Fix the Embedded PDF File to a Cell

When you embed a PDF file in Excel, it is inserted as an object that sits above the worksheet cells. The position of the icon would not change if you change the cells below it.

For example, when you place the icon within a cell, it would not move with the cells and would not get filtered, sorted, or hidden with the cells.

As shown below, if you hide the cell that has the PDF file, it doesn’t hide the PDF.

To make sure it sticks to the cell:

  • Insert the file icon within the cell. If it doesn’t fit, either resize the icon or the cell so that the icon is within the cell.
  • Right-click on the icon and select Format Object. (If you have multiple PDF files embedded, you can select all and then right-click and select the Format Object option.)How to insert a pdf into excel
  • In the Format Object dialog box, select Properties tab and select the option ‘Move and size with cells’How to insert a pdf into excel
  • Click OK.

Now when you filter or sort/filter the cells, or hide the rows, the PDF object will do the same.

Renaming the Embedded PDF File

When you embed a PDF file in Excel, it gets a generic name such as “Adobe Acrobat Document”.

You can change this name by following the below steps:

  • Right-click on the PDF object and select Convert option in the Acrobat Document Object. How to insert a pdf into excel
  • In the Convert dialog box, click on the Change Icon button.
  • In the Change Icon dialog box, change the caption to the name you want for the embedded PDF document.How to insert a pdf into excel
  • Click OK.

Forum Contributor Join Date 09-28-2017 Location UK MS-Off Ver 2016 Posts 139

Embedding a PDF into an Excel Worksheet

I am trying to embed a single PDF file into an Excel worksheet. The PDF consists of multiple pages, and I am hoping to be able to embed the PDF so that a user can scroll through its pages within Excel – not just click an embedded link and open the PDF separately within Acrobat.

No idea if this is even possible, does anyone have any ideas?

Many thanks in advance,

  • View Profile
  • View Forum Posts

Forum Expert Join Date 11-24-2014 Location Texas MS-Off Ver Office 2010 and 2007 Posts 3,448

Re: Embedding a PDF into an Excel Worksheet

1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 – 573PH3N H4WK1NG
You don’t have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

  • View Profile
  • View Forum Posts

Forum Contributor Join Date 09-28-2017 Location UK MS-Off Ver 2016 Posts 139

Re: Embedding a PDF into an Excel Worksheet

  • View Profile
  • View Forum Posts

Forum Expert Join Date 11-24-2014 Location Texas MS-Off Ver Office 2010 and 2007 Posts 3,448

Re: Embedding a PDF into an Excel Worksheet

  • View Profile
  • View Forum Posts

Forum Expert Join Date 11-24-2014 Location Texas MS-Off Ver Office 2010 and 2007 Posts 3,448

Re: Embedding a PDF into an Excel Worksheet

  • View Profile
  • View Forum Posts

Forum Contributor Join Date 09-28-2017 Location UK MS-Off Ver 2016 Posts 139

Re: Embedding a PDF into an Excel Worksheet

I am hoping to find a way to actually scroll through the PDF within Excel, as opposed to open the PDF separately. I wonder therefore if I should be looking to embed Acrobat into the worksheet?

The PDF in question consists of 200 pages and comes with a number of bookmarks for different sections, which are almost always used by the end user.

Just trying to find a neat way to do this so the user doesn’t need to juggle between Excel and Acrobat, or mess around multiple times per day opening and resizing the windows to use them side-by-side.

How to insert a pdf into excel

PDF (Portable Document Format) can help both individual and business users to share information that can be viewed the same, no matter what kind of program or device it is opened on. If you are looking to insert PDF into excel, here we provide three solutions below including with PDFelement.

Method 1. Steps to Insert PDF into Excel 2016, 2013, 2010 for Free

You will need to insert the PDF document into your excel document as an object. In some cases, you’ll be able to open, view, resize, and even edit the inserted PDF document. Here’s how to insert PDF into excel.

Step 1. Open an Excel Document

After opening an excel document, click the “Insert” > “Object” button in the Text section.

How to insert a pdf into excel

Step 2. Insert PDF into Excel

In the pop-up dialog box, go to the “Create from File” tab and use the “Browse” button to select the PDF document that you want to insert.

How to insert a pdf into excel

Step 3. Display as an Icon

Select the option of “Display as icon,” and change the icon display name, then click the “OK” button to complete the process.

Method 2. How to Insert PDF into Excel as Image

There is another way to insert PDF into Excel that you can transfer the PDF into an image. For that, PDFelement can help you convert a PDF document to an image file so that you can insert it into excel directly.

Step 1. Load a PDF

After launching PDFelement, click the “Open files” button on the Home window to load your PDF file in it.

How to insert a pdf into excel

Step 2. Convert PDF

Click the “Convert” > “To Image” button to convert the PDF to an image file, and save it in your local folder.

How to insert a pdf into excel

Step 3. Insert PDF into Excel

Open the Excel document, click the “Insert” > “Picture” button to choose the converted image to be inserted from your local folder.

How to insert a pdf into excel

Method 3. How to Insert PDF File in Excel

What’s more, converting PDF to an excel file is another way for you to insert PDF into excel with PDFelement.

Step 1. Import the PDF

Open PDFelement, you can drag and drop a PDF file into it or tap on the “Open files” button.

How to insert a pdf into excel

Step 2. PDF to Excel

Click the “Convert” > “To Excel” button to convert your PDF document to an excel file. Then you can open the converted excel file to copy the content and paste it into another excel file.

How to insert a pdf into excel

Read or Edit PDFs before/after Inserting PDF into Excel

The above steps are the simplest way to insert PDF into excel as an object. However, if you want to read or edit the PDF document before inserting it into the excel document, you should have a PDF editor program installed on your computer to read and edit the PDF files before or after adding PDF into excel. This is why PDFelement is so widely used. It can help you view, annotate, edit, create, and convert PDF documents quickly and easily.

  • It allows you to convert PDF files to other formats, including Excel, Word, PowerPoint, HTML, and Text, etc.
  • You can edit not only PDF text but also PDF images with its smart editing modes.
  • With the user-friendly interface, you can use PDFelement without a steep learning curve.
  • The embedded OCR (Optical Character Recognition) feature enables you to convert image-based PDFs or scanned PDFs into searchable and editable text documents.
  • You can create PDF documents from scratch, from other file formats, or even from web pages.
  • The batch process feature makes it easy to deal with a large number of documents.

Edit PDF Documents with Ease

If you want to annotate or edit a PDF document before or after inserting it into an excel sheet, PDFelement should be the first choice. It provides various tools for you to annotate or make comments in the PDF document. Additionally, it also enables you to edit PDF text as easily as possible.

How to insert a pdf into excel

Attach Excel into PDF

PDFelement also enables you to add an Excel document into a PDF document if you want to display data within your PDF file. After opening a PDF document with PDFelement, you can click the “Comment”>”Add Attachment” button to browse an excel document to add.

Marshall Gunnell
How to insert a pdf into excelMarshall Gunnell
Writer

Marshall Gunnell is a writer with experience in the data storage industry. He worked at Synology, and most recently as CMO and technical staff writer at StorageReview. He’s currently an API/Software Technical Writer at LINE Corporation in Tokyo, Japan, runs ITEnterpriser, a data-storage and cybersecurity-focused online media, and plays with development, with his RAID calculator being his first public project. Read more.

How to insert a pdf into excel

Excel provides a plethora of features for organizing, manipulating, and handling your data. One of these unique features is inserting a PDF directly into Excel. The good news is it only involves a few simple steps to do it. Here’s how.

Inserting a PDF Into Excel

In the Excel file, head over to the “Insert” tab and then click the “Object” button.

How to insert a pdf into excel

In the Object window that appears, switch to the “Create from File” tab and then click “Browse.”

How to insert a pdf into excel

Browse to the location of your file, select the file, and then click “Open.”

How to insert a pdf into excel

Back at the “Object” window, you’ll see the file path of your PDF. Now, you need to tell Excel how you want the file to appear in the spreadsheet. There are a few different options here. If you select “OK” without taking any further action in the “Object” window, the PDF file appears in Excel showing the contents of the PDF in its entirety.

How to insert a pdf into excel

Alternatively, you can check the box next to “Display as icon” for a less intrusive option. This method, as the name suggests, inserts an icon that represents the contents of your file. Double-clicking the icon opens the file in your computer’s default PDF viewer.

How to insert a pdf into excel

Another solution would be to check the “Link to file” option. This option, as with the others, places the content of your PDF into Excel. The difference here is that it creates a link to the source file, making it a live document. Any changes to the source file would be reflected in your document.

Also keep in mind that you can select both the “Link to file” and “Display as icon” options, creating a less intrusive method of accessing a live document.

Once you’ve selected the option that works best for you, click “OK.”

How to insert a pdf into excel

Your PDF will now be inserted into Excel as an icon.

How to insert a pdf into excel

You’ll notice that once inserted, the PDF takes on an “In front of text” layout style and hovers above the cells. If you want to anchor the PDF to (and format with) a specific cell, then right-click the icon and select “Format Object” from the drop-down menu.

How to insert a pdf into excel

The “Format Object” window will now appear. There are several different things you can do here, including changing the size and color, cropping, and even adding alt text to the object. What we’re particularly interested in here, though, is object positioning.

First, select the “Properties” tab. You’ll find a few options concerning the positioning of the object. Here, select “Move and size with cells” and then click “OK.”

Note: If you don’t want the icon to appear in the printed version of the sheet, untick the “Print object” checkbox.

How to insert a pdf into excel

Now any changes made to the cell, including hiding or resizing, will also apply to the icon.

Repeat these steps to insert multiple PDF files in your Excel sheet.

  • › How to Show Your Work Hours and Location in Google Calendar
  • › You Can Finally Move WhatsApp Chats From iPhone to Android
  • › How to Print Double-Sided on Windows 11
  • › Samsung Galaxy Phones Are Getting Grammarly Installed by Default
  • › How to Enable Cookies in Google Chrome

How to insert a pdf into excel Marshall Gunnell
Marshall Gunnell is a writer with experience in the data storage industry. He worked at Synology, and most recently as CMO and technical staff writer at StorageReview. He’s currently an API/Software Technical Writer at LINE Corporation in Tokyo, Japan, runs ITEnterpriser, a data-storage and cybersecurity-focused online media, and plays with development, with his RAID calculator being his first public project.
Read Full Bio »

How to insert a pdf into excel

Are you fed up looking for the best way to embed PDF in Excel? Yes, the lack of know-how can prove quite frustrating. Luckily, we have compiled for you a thorough guide on how to embed PDF in Excel with ease and speed.

Method 1: How to Embed PDF in Excel

A vast majority of people have used Microsoft Excel to settle and save some data related works. However, a few have explored the plethora of features Microsoft Excel offers. Free of bias, Microsoft Excel provides plenty of features that transform the way you organize, manipulate, and handle your data. One of such features is embedding or inserting a PDF file directly into Excel. This is a seamless process and should not send cold through your nerves since you are just a few clicks away to complete.

How to Embed PDF in Excel using Microsoft Excel

Step 1. Open Excel file you want to embed a PDF file on Microsoft Excel.

Step 2. Click the “Insert” tab and choose “Text” then hit the “Object” icon. This action will open the “Object” window.

How to insert a pdf into excel

Step 3. Within the Object window, select the “Create New” option. Check the boxes “Display as Icon” to determine how you will embed your PDF. It will give you an option to browse for the PDF file you want to embed in the Excel file.

How to insert a pdf into excel

Step 4. Click “OK” and search for the PDF file in the file directory. Once located, highlight and click “Open” to import to Excel.

Step 5. Your PDF file is now embedded in the Excel file. So, if you want to view the PDF content, you simply click the PDF link or object in the Excel file.

How to insert a pdf into excel

Method 2: How to Embed a PDF in Excel

Embedding PDF on Excel has never been simple before. Thanks to the amazing PDFelement. With this program, you can embed PDF in Excel as an image or simply convert it to Excel and then copy and paste the contents into the desired Excel file. The entire process is plain sailing, and no expertise is required at all.

Step 1. Open PDF file

Launch PDFelement on your computer to display the primary window. At the bottom left, click the “Open File” tab to open the file directory. Browse the PDF file you want to embed on the Excel file and hit “Open” to import it into the program’s main interface.

How to insert a pdf into excel

Step 2. Convert PDF to Image

When the PDF file is successfully uploaded, click the “Convert” button on the menu bar. From the submenu, select the “To image” option. By doing so, the program will convert your PDF file into an image.

How to insert a pdf into excel

Step 3. Insert Image to Excel

Now click to run the Microsoft Excel program on your computer. On the main window, click the “Insert” tab and, subsequently, the “Pictures” option. From the displayed file explorer window, navigate to the save location for the image you generated from PDF using PDFelement. Select the image and click “Insert”. Your PDF file will now be embedded in the Excel file as an image.

How to insert a pdf into excel

If your interest is to insert PDF content on the Excel file, a good option could be first to convert the PDF into Excel. Once converted, open the newly created Excel file and copy the target contents. Now paste the contents into the Excel file you wanted to embed the PDF content.

How to insert a pdf into excel

PDFelement is a powerful program that provides a convenient and efficient way to deal with PDF files. This fantastic PDF tool allows users to create, convert, edit, review, and secure PDF files with less effort. The elegant interface, super-fast processing and rendering speed, and outstanding output quality are some of the significant highlights of PDFelement. This program houses nearly everything you would demand from an ideal PDF tinker tool.

How to insert a pdf into excel

Depending on the type of document you are creating, sometimes it may become necessary to attach another document within the one you are working on. This is primarily important when the attachment, in this case PDF contains additional information that supports the information that is already on the excel document. While this seems like a very useful solution when creating detailed reports, many don’t know how to attach PDF in Excel. In this article, we provide a simplified operating process for you.

How to Attach PDF File in Excel

The following simple steps will guide you to attach PDF to Excel spreadsheet:

Step 1: Open the Excel document that you want to attach a PDF document to.

Step 2: Click on the “Insert” tab and then select the “Object” icon located in the “Text” group of tools.

How to insert a pdf into excel

Step 3: In the “Object” dialogue box that appears, click on “Create New” and then choose “Adobe Acrobat Document” from the list of options.

Note: For this process to work, you must have Adobe Reader or PDFelement installed on your computer.

Step 4: Check the “Display as icon”

How to insert a pdf into excel

Step 5: Click “OK” and then select the particular PDF document that you want to attach to the Excel document. Click “Open” and the PDF will be attached to the Worksheet.

How to insert a pdf into excel

The Best PDF Software for You

Sometimes you may need to edit the PDF document that you want to attach to Excel. It is necessary for you to make sure that the information or details in the PDF document match content in the Excel workbook. But most PDF editing tools can complicate the whole process, making it difficult and time-consuming.

There is however a PDF management program making the process of editing or managing PDF documents much easier. This is PDFelement and the following are just some of its the most useful features:

  • It makes PDF creation very easy, all you have to do is drag a document from any format into PDFelement and convert it to PDF.
  • You can also use it to edit all aspects of the PDF including the images and texts, links, etc.
  • It also has great annotation features including the ability to add comments, highlight text and even add custom stamps to the document.
  • It also comes with an OCR function that is used to transform scanned or image-rich PDFs into editable formats.
  • It can also easily convert PDFs to other formats including Word, Excel, PowerPoint, HTML, EPUB and so on.
  • It has a high security function that can apply passwords and permissions to protect the PDF document.
  • It can view, share and print PDF documents.

How to Attach Document in PDF

If you want to add a document in the PDF document that you are working on as a way to improve the information in the document, PDFelement can help you add the attachment as a comment.

  • Step 1: Open the PDF document that you want to add an attachment to.
  • Step 2: Once the document is open, click on the “Comment” tab at the top and then click on “Add Attachment”. Click on the location of the page where you want to add the comment.
  • Step 3: A dialogue box will appear where you can select the file you want to attach. Click on the file you want and then click “Open”
  • Step 4: Once the attachment has been added, you can right-click on it and select “Properties” to get additional options. In the “Properties” panel on the right, you can change the icon’s style, color, opacity or any other options as you see fit.

How to insert a pdf into excel

How to Edit PDF

You can also use PDFelement to edit the PDF text and images. To do that, you can click on the “Edit” tab at the top and then select “Edit Text”. Moreover, you also need to choose “Paragraph Mode” or “Line Mode” to edit text.

Click on the text you want to edit within the document and then simply edit the text as you would with any other text editor. You can also easily change the font, font size, bold, italic and colors as you need to.

How to insert a pdf into excel

How to Convert PDF

PDFelement also allows you to convert the PDF document to a number of other formats. This process is quite easy; once the document is open in PDFelement, you just need to simply click on the “Convert” tab at the top and then select the output format in the list provided below the main menu.

For example, if you want to convert the document to Word, click on “Convert > To Word” and select the output format to begin the conversion process. You can also use it to convert multiple documents at once.

As the inventor of the PDF file format, Adobe makes sure that the Acrobat PDF to Excel converter tool creates a high-quality file you can work with on Mac or Windows. The Acrobat functionality transfers your PDF data and content right into an Excel spreadsheet, where you can edit the rows and columns.

You can also try Adobe Acrobat Pro DC for free for seven days to edit PDFs with optical character recognition (OCR technology), split PDFs, reduce file size, convert Microsoft 365 files to PDF, and export PDFs to Microsoft Word, PowerPoint, and Excel.

What’s the difference between XLS and XLSX?

The XLS and XLSX file formats are file extensions used by Microsoft Excel. The XLS file format is an older format used by Microsoft Excel 2003 and earlier. With the release of Microsoft Excel 2007, Microsoft introduced the new XLSX file format based on the Open XML (Extensible Markup Language) standard. If you have Microsoft Excel 2003 or earlier, you’ll need to download the free Microsoft Office Compatibility Pack to open, edit, and save XLSX files.

How can I open my converted file?

It’s easy to open converted files. After the PDF to Excel conversion, download your new Excel workbook. Then launch Microsoft Excel, choose Open from the File menu, and select the converted file to open. You can also sign in to Acrobat online services to save your converted Excel document to Adobe Document Cloud for quick online access from anywhere.

Summary : The tutorial below will show users how to insert PDF into an Excel spreadsheet on Microsoft Excel with the help of Bitwar PDF Converter.

Excel cell is one of the most important documents on the Internet because it provides many powerful and useful tools for calculation and spreadsheets. Therefore, the Excel spreadsheet is a must document for everyone, just like a word file.

Sometimes, users might need to add or merge original documents into excel, for example, insert PDF into Excel cell. Still, not all users know how to add or insert the PDF file because the file format differs from Excel.

So don’t panic as the guideline below will teach users how to insert PDF into Excel spreadsheet easily!

Table of Contents

How to Insert PDF into Excel on Microsoft Excel

How to insert a pdf into excel

Actually, all users can insert the PDF file through the Insert menu in different versions of Microsoft Excel, which includes 2007, 2013, 2016, 2019 and 2020.

Step 1: Open the Excel cell in Microsoft Excel and click the Insert menu next to the Home button.

Step 2: Choose the Object button from the Text tab.

Step 3: From the Object window, click Create from File and browse the PDF file. Finally, click OK to insert the PDF file.

How to insert a pdf into excel

Suppose that users don’t want the PDF file to be visible in the Excel spreadsheet. Remember to tick the Display as Icon box. Besides, users also can insert the PDF file by ticking the Link to file option to link the PDF Document to the Excel cell.

How to Insert Multiple PDF Pages into Excel Cell

Just in case users need to insert different pages from a PDF file into Excel at a different location. The steps mentioned above will be a problem for users, so during this time, the PDF Converter will be helpful for users.

The only way for users to insert multiple PDF pages into Excel is to split the PDF and add the page separately into Excel. Users can use the Split PDF tool in PDF Converter to split the PDF file first and follow the steps mentioned above to insert the PDF pages into Excel.

Learn It Quickly!

Users can insert PDF into Excel easily by following the tutorial above. Sometimes some users may need to copy or transfer the data from Excel to PDF file or vice versa in some situations, and users can convert the Excel to PDF or PDF to Excel easily by using the PDF Converter.

We can learn how to insert PDF into our Excel Worksheet with ease. It’s easy to embed file in Excel once we have a PDF Reader and Microsoft Office. It is convenient when we wish to display some of our data in a manner that remains the same for all users. This tutorial will teach all levels of excel users how to embed or insert PDF into an Excel worksheet.

How to insert a pdf into excelFigure 1 – Insert PDF into Excel

Embed PDF in excel Worksheets

  • We will go to the Insert tab and select the Object icon in the Text group

How to insert a pdf into excelFigure 2 – How to insert PDF into Excel

  • In the Object dialog box , we will tap on Create New and select the PDF Reader we have from the list

How to insert a pdf into excelFigure 3 – Insert PDF into Excel

Note: We must have previously installed a PDF reader of our choice to our computer

  • Now, we will mark the option “ Display as icon ” and click OK

How to insert a pdf into excelFigure 4 – How to embed PDF into Excel

  • Next, we will select the PDF file we wish to embed in our Worksheet and click open
  • Once the PDF is inserted, it will open by default. We can close the PDF and continue working on our Excel document.

How to insert a pdf into excelFigure 5 – Embedding a PDF in Excel

How to fix the Embedded PDF file to a Cell

We can embed our PDF file to have its object sitting in one of our worksheets cell. This icon will not change even when we change the cells below it. It will not also move when we sort, hide or filter cells in that same column or row. To do this:

  • Once we have embedded our Excel PDF file, we will close the PDF so we can see the display icon

How to insert a pdf into excelFigure 6 – Attach file to Excel

  • We will insert the file icon into a cell.

How to insert a pdf into excelFigure 7 – Insert a PDF into excel

  • Next, we will right click on the icon and select Format Object
  • We will go to properties and select the option “Move and Size with cells” and click OK

How to insert a pdf into excelFigure 8 – How to insert a PDF into Excel

How to rename the embedded PDF file

We can change the generic name because it will probably be displayed using the name of the PDF reader. This is vital if we wish to embed more than one PDF

  • We will right click on the PDF object
  • Next, we will select the Convert Option

How to insert a pdf into excelFigure 9 – Embed PDF into Excel

  • In the Convert dialog box, we will click on the Change Icon button

How to insert a pdf into excelFigure 10 – How to insert PDF to Excel

  • Now we can change the image by clicking browse.

How to insert a pdf into excelFigure 11 – Embed document in Excel

  • We can also change the name by entering our desired name in the Caption button

How to insert a pdf into excelFigure 12 – Excel insert PDF

  • We will click OK

How to embed multiple PDFs in an Excel Worksheet

We can insert more than one PDF into our worksheet. All we need do is follow the steps for embedding one PDF into our Excel Worksheet. To resize all our Excel PDF icons at once,

  • We will hold the Ctrl Key and select all PDF icons i n our Excel Sheet
  • Next, we will right click to select Format Object

How to insert a pdf into excelFigure 13 – How to insert a file into Excel

  • We will go to properties and select the option “Move and Size with cells” and click OK

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.