There’s always a joke going on on the internet – no matter what major you study or where you work, Microsoft Excel will eventually become the most sought-after skill. That’s right, there’s a lot you can do on an Excel sheet. We recently discovered that you can insert PDF documents into Excel spreadsheets.
Multi-page PDF documents can contain a lot of information, and adding all of them to an Excel Spreadsheet is difficult. As a result, you can quickly embed a PDF file in Excel to provide more context for the added information. Let’s explore 3 ways to help you do it easily.
1. Insert a PDF document into an Excel spreadsheet
Here’s how you can insert a PDF file into Excel and ensure that the document is visible and easily accessible on the Excel spreadsheet.
Step 1: Open the Excel spreadsheet that you want to add the PDF file to.
Step 2: Click the Insert button on the toolbar.
Step 3: Tap Text.
Step 4: Select Object in the drop-down box.
Step 5: In the Object dialog box, select ‘Adobe Acrobat Document’ as the Object type.
Step 6: Click OK.
Step 7: Adobe PDF reader will open in background. To access the window, click the Adobe reader icon on the taskbar.
Step 8: Select the PDF file you want to insert and click Open.
Step 9: The PDF is now inserted into your Excel spreadsheet. You can also move and resize the PDF screen.
The PDF will also open in Adobe Reader. When you scroll to the next page of a document in Adobe Reader, the document in Excel will also show the change in page.
However, if you don’t want a large preview of the PDF document on your Excel spreadsheet, you can consider adding a link to the PDF document.
2. Embed PDF file link in Excel spreadsheet
Here’s how you can add hyperlinks to a PDF document in an Excel spreadsheet. This way you can save a lot of space and simplify your spreadsheets.
Step 1: Open the Excel spreadsheet that you want to add the PDF file to.
Step 2: Click the Insert button on the toolbar.
Step 3: Tap Text.
Step 4: Select Audience from the drop-down box.
Step 5: Click Create from file.
Step 6: Tap Browse.
Step 7: Select the PDF file and click Insert.
Step 8: Check the ‘Link to file’ box and click OK.
Step 9: The link is now inserted into the PDF document. You can move it around and resize it in the spreadsheet.
Step 10: To open the link, double-click it and tap Open.
You also have an option to insert the PDF document as an icon in your spreadsheet. Here’s how you can do it.
3. Insert PDF Document as Icon in Spreadsheet
A small icon looks very small in a spreadsheet, and you can quickly open an embedded PDF by clicking on it. Follow the steps below to insert a hyperlink to a PDF document on an icon.
Step 1: Open the Excel spreadsheet that you want to add the PDF file to.
Step 2: Click the Insert button on the toolbar.
Step 3: Tap Text.
Step 4: Select Audience from the drop-down box.
Step 5: Click Create from file.
Step 6: Tap Browse.
Step 7: Select the PDF document you want to insert and click Insert.
Step 8: Check the ‘Show as icon’ box and click OK.
Note: You can also change the icon for the PDF by selecting the change icon button in the dialog box.
Step 9: The icon for the PDF document is inserted into your spreadsheet. You can move and resize the icon by dragging it along the edges.
Step 10: To open the document, double-click the icon and then click Open.
These are all the ways that you can insert PDF documents into Excel spreadsheets.
However, there are several ways you can adjust this inserted PDF document in an Excel spreadsheet. Here’s how you can format it. These options work for all three ways that you insert PDF documents.
PDF Inserted Format in Excel Spreadsheet
Step 1: Right click on the PDF document.
Step 2: Tap Format Object.
Step 3: Click the Properties tab. You will find three options.
Let’s see what each of these options does.
Move and resize with cells: Selecting the option ensures that parts of the document are resized when the corresponding cells are resized as well. As you can observe in the image below, columns E and F have increased in width and you can see how the corresponding sections of the document have also increased in width.
Move but don’t resize with cells: Selecting this option ensures the PDF document doesn’t have any effect while resizing cells. As you can see in the image below, column F is quite narrow but there is no change in the corresponding sections of the PDF document.
Do not move or resize by cells: Selecting this option will lock your PDF document in the Excel file, and resizing cells will not have any effect on the document.
That’s it, that’s everything you need to know about inserting PDF documents into Excel Spreadsheets. Now that you have embedded PDF documents in your Excel sheet, you can consider protecting them with a password to further secure them.
If you have any related questions, check out the FAQ section below.
frequently asked Questions
1. How many PDF documents can you insert into an Excel workbook?
You can add any number of PDF documents to your spreadsheet.
2. Can you save an Excel Spreadsheet as a PDF document?
Correct. In the ‘Save As’ option, you can choose to save the Excel document as a PDF file.
Everything is connected
We hope this article helped you easily insert PDF documents into Excel spreadsheets. You can easily insert links or icons into PDF documents, instead of copying and pasting all the contents of the PDF into a spreadsheet. This way you can simplify your Excel document and make it less confusing.
Categories: How to
Source: thpttranhungdao.edu.vn/en/
