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. Learn about our Tech Review Board
Updated May 20, 2024Here’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 the Insert button on the toolbar, and tap on Text. Select Object in the drop-down box.
Step 2: Select Adobe Acrobat Document as Object type. Tap on OK.
Step 3: The Adobe PDF reader will now open in the background. To access the window, click on the Adobe Reader’s icon on the taskbar.
Step 4: Select the PDF you want to insert and tap on Open.
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.
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 the Insert button on the toolbar, and tap on Text. Select Object in the drop-down box.
Step 2: Tap on Create from File and select Browse.
Step 3: Select the PDF file and tap on Insert.
Step 4: Check the box for Link to File and tap on OK.
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-click on it and tap on Open.
With a small PDF icon, you can quickly open up the embedded file by clicking on it
Step 1: Tap on the Insert button on the toolbar, and tap on Text. Select Object in the drop-down box.
Step 2: Tap on Create from File. Tap on Browse.
Step 3: Select the PDF document that you want to insert and click on Insert.
Step 4: Check the box for Display as icon and tap on OK.
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-click on the icon and then tap on Open.
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 the PDF object. Tap on Format Object.
Step 2: Tap on the Properties tab. 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.
