3 Ways to Insert a PDF Document into an Excel Spreadsheet on Windows

Supreeth is passionate about technology and dedicates himself to helping people figure it out. An engineer by education, his understanding of the inner workings of all types of gadgets and devices ensures he provides top-notch guidance, tips, and recommendations to his readers. When away from the desk, you will find him traveling, playing FIFA, or hunting for a good movie.

Method 1: Insert a PDF Document in Excel Spreadsheet

Here’s how you can insert a PDF into Excel and make sure the document is visible and easily accessible on the Excel spreadsheet.

Step 1:Tap on theInsertbutton on the toolbar, and tap onText. SelectObjectin the drop-down box.

Step 2:SelectAdobe Acrobat Documentas Object type. Tap onOK.

Step 3:The Adobe PDF reader will now open in the background. To access the window, click on theAdobe Reader’s icon on the taskbar.

Step 4:Select the PDF you want to insert and tap onOpen.

The PDF is now inserted into your Excel spreadsheet. You can also move and resize the PDF display.

The PDF will be opened in Adobe Reader as well. As you scroll to the next page of the document in Adobe Reader, the document in Excel will also display the change in the page.

Also Read:How to use the filter and sort data function in Microsoft Excel.

If you do not want the large preview of the PDF document on your Excel spreadsheet, you can consider adding a link to the PDF document.

Step 1:Tap on theInsertbutton on the toolbar, and tap onText. SelectObjectin the drop-down box.

Step 2:Tap onCreate from Fileand selectBrowse.

Step 3:Select the PDF file and tap onInsert.

Step 4:Check the box forLink to Fileand tap onOK.

Step 5:The link is now inserted in the PDF document. You can move around and resize it within the spreadsheet. To open the link,double-clickon it and tap onOpen.

Also Read:How to view multiple worksheets side-by-side in Excel.

Method 3: Insert the PDF Document as an Icon in the Spreadsheet

With a small PDF icon, you can quickly open up the embedded file by clicking on it

Step 1:Tap on theInsertbutton on the toolbar, and tap onText. SelectObjectin the drop-down box.

Step 2:Tap onCreate from File. Tap onBrowse.

Step 3:Select the PDF document that you want to insert and click onInsert.

Step 4:Check the box forDisplay as iconand tap onOK.

Note: You can also change the icon for the PDF by selecting the change icon button in the dialog box.

Step 5:The icon for the PDF document is inserted into your spreadsheet. You can move and resize the icon by dragging it along the edges.

To open the document,double-clickon the icon and then tap onOpen.

Also Read:How to compare columns in Excel for matches.

Format Inserted PDF in the Excel Spreadsheet

There are a few ways in which you can move, or resize inserted PDF objects in the Excel spreadsheet. These options work for all three ways in which you insert the PDF document.

Step 1:Right-click on thePDF object. Tap onFormat Object.

Step 2:Tap on thePropertiestab. You will find three options.

Let us take a look at what each of these options does.

Move and Size With Cells: Selecting the option ensures parts of the document are resized when the corresponding cells are resized too.

As you can observe in the image below, columns E and F have increased in width and you can see how the corresponding parts of the document have increased in width too.

Move but don’t size with cells: Selecting this option ensures the PDF document does not have any effect while resizing the cells.

As you can observe in the image below, column F is quite narrow but there is no change in the corresponding parts of the PDF document.

Don’t Move or Size With Cells: Selecting this option locks your PDF document in the Excel file and resizing the cells will not have any effect on it.

Was this helpful?

Last updated on 20 May, 2024

Leave a ReplyCancel reply

Your email address will not be published.Required fields are marked*

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Windows

How to View Samsung Notes on Windows

8 Fixes for “Your Device Is Missing Important Security and Quality Fixes” on Windows

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.