Excel offers a variety of functions for organizing, editing, and processing your data. One of these unique features is the direct insertion of a PDF file into Excel. The good news is that there are only a few simple steps to do this. This is how it works:
Inserting a PDF into Excel
In the Excel file, go to the "Insert" tab and click the "Object" button.
In the object window that appears, go to the "Create from File" tab and click "Browse".
Navigate to the location of your file, select the file, and click Open.
Back in the Object window, the file path of your PDF file is displayed. Now you need to tell Excel how to display the file in the table. There are different ways. If you select "OK" in the "Object" window without performing any further actions, the PDF file is displayed in Excel and shows the entire contents of the PDF file.
Alternatively, you can select the check box next to Show as Icon for a less intrusive option. This method, as the name implies, inserts a symbol representing the contents of your file. Double-clicking the icon opens the file in the default PDF viewer on your computer.
Another solution would be to enable the option "Link to file". This option, like the others, places the contents of your PDF file in Excel. The difference is that a link to the source file is created so that it is a live document. Any changes to the source file will be reflected in your document.
Also, be aware that you can select both "Link to File" and "Show as Icon" options to make your live document less intrusive.
When you have selected the option that best suits you, click OK.
Your PDF is now inserted as a symbol in Excel. 
You will notice that after pasting, the PDF assumes a layout style "Before Text" and hovers over the cells. If you want to anchor (and format) the PDF file to a specific cell, right-click the icon and choose Format Object from the drop-down menu.
<img class = "alignnone size-full wp-image-416034" data-pagespeed-lazy-src = "https://www.howtogeek.com/wp-content/uploads/2019/05/xFormat-object .png.pagespeed.gp + jp + jw + pj + ws + js + rj + rp + rw + ri + cp + md.ic.yAWdfJ43dl.png "alt =" Format Object "width =" 198 "height =" 202 "src =" /pagespeed_static/1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); " onerror = "this.onerror = null;]
The Format Object window now appears, allowing you to perform various actions, such as resize and color, crop, and even add alternate text to the object However, the object positioning is particularly interesting here.
First select the "Properties" tab, you will find some options for positioning the object, select "Move and size with cells" and then click on "OK". Note: If the icon does not appear in the printed version of the sheet, deselect "Print Item."
Any changes made to the cell, including hiding or resizing, now apply to the icon.
Repeat these steps to insert multiple PDF files into your Excel spreadsheet.