Ticking the “Link to file” option in the object’s options will both place the contents of your PDF into the document and link it to the original file. Link the file to create a live document.Double-clicking the icon will open the full PDF. The icon will look something like this, with your filename handily displayed below it. If you want the PDF to take up a smaller portion of your screen, you can tick the “Display as icon” box when you insert it as an object instead. It will show the PDF content so you can quickly reference it at a glance.

The first way Excel can display PDF documents is pictured below.

Select your PDF you want to import and press “Open”.

Switch to the “Create from File” tab and browse for your PDF.

Open the “Insert” tab on your ribbon, then click “Text > Object”.

Rather than a dedicated button, you embed a PDF in Excel via the text menu. Switch to the Insert tab and add a text object.As you’d imagine the process to insert a PDF starts in the ribbon’s “Insert” tab, but the next steps are a little less intuitive.

Insert excel table into pdf