top of page

How to Embed a PDF into Excel

If you want to insert a PDF file into an Excel worksheet, you have a few options. You can either link to the PDF file, embed the PDF file as an object, or convert the PDF file to an image and insert it as a picture. In this blog post, we will show you how to do each of these methods, with examples and images to guide you.

Linking to a PDF File


The simplest way to insert a PDF file into Excel is to link to it. This means that you create a hyperlink in a cell that opens the PDF file when you click on it. To do this, follow these steps:


1. Select the cell where you want to insert the link.

2. Go to the Insert tab and click on Link in the Links group.

3. In the Insert Hyperlink dialog box, select Existing File or Web Page in the left pane.

4. Browse to the location of the PDF file and select it.

5. Click OK.


You will see a hyperlink in the cell that displays the file name of the PDF file. You can change the text of the link by editing the cell. When you click on the link, it will open the PDF file in your default PDF viewer.


Embedding a PDF File as an Object


Another way to insert a PDF file into Excel is to embed it as an object. This means that you insert the entire PDF file into the worksheet, and you can view it or edit it within Excel. To do this, follow these steps:


1. Select the cell where you want to insert the PDF file.

2. Go to the Insert tab and click on Object in the Text group.

3. In the Insert Object dialog box, select Create from File in the left pane.

4. Browse to the location of the PDF file and select it.

5. Check the Display as icon option if you want to show only an icon of the PDF file, or uncheck it if you want to show the first page of the PDF file.

6. Click OK.


You will see either an icon or a preview of the PDF file in the worksheet. You can resize or move it as you like. To view or edit the PDF file, double-click on it. It will open in your default PDF viewer or editor.


Converting a PDF File to an Image and Inserting it as a Picture


The third way to insert a PDF file into Excel is to convert it to an image and insert it as a picture. This means that you create a snapshot of each page of the PDF file and save them as image files, such as JPEG or PNG. Then, you insert them into the worksheet as pictures. To do this, follow these steps:


1. Open the PDF file in your default PDF viewer or editor.

2. For each page of the PDF file, use the Print Screen key on your keyboard or a screenshot tool to capture an image of the page.

3. Paste each image into an image editing software, such as Paint or Photoshop, and save them as image files in a folder.

4. Go back to Excel and select the cell where you want to insert the first image.

5. Go to the Insert tab and click on Picture in the Illustrations group.

6. In the Insert Picture dialog box, browse to the folder where you saved the image files and select the first one.

7. Click Insert.


You will see the image of the first page of the PDF file in the worksheet. You can resize or move it as you like. Repeat steps 4-7 for each image file until you have inserted all pages of the PDF file into Excel.


Conclusion


In this blog post, we have shown you how to insert a PDF file into Excel using three different methods: linking, embedding, or converting to images. Each method has its own advantages and disadvantages, depending on your needs and preferences. We hope this tutorial has been helpful for you and that you have learned something new today.

 

Comments


  • linkedin

V & A Waterfront, Cape Town, 8001, South Africa

©2017 BY NEIL VAN WYNGAARD. PROUDLY CREATED WITH WIX.COM

bottom of page