How to Embed a PDF in Excel
Embedding a PDF in Excel allows you to store your documents safely in one place. This is especially handy if you need to share a variety of documents with other people.
It's no secret that Excel spreadsheets are a vital tool for many workplaces. They can be necessary for accounting, calculation, budgeting, and beyond. Learning how to embed a PDF within Excel can help you stay organised and make it easier for your team to access all the information they need.
If you need to attach an invoice when making a list of incoming or outgoing funds or you want to include supporting information within a budget summary, you'll need to learn how to insert a PDF into Excel.
Discover how to embed a PDF in Excel with our helpful guide.
Ready to try Adobe Acrobat? Start your free trial.
How to embed a PDF in Excel in 4 quick steps.
To insert PDF link into Excel, follow these simple steps:
1. Open your files. Open up the Excel spreadsheet that you want to place the link into and select Insert > Object.
2. Add your PDF. Click Create > Browse to locate the PDF you want to insert.
3. Check the display. Before clicking OK, check the boxes that says Link to file and Display as icon. Now right click on the PDF icon and select Format Object.
4. Embed your PDF. From this pop-up window, click Properties, then Move and size within cells.
Embedding and formatting a PDF in Excel.
While the above list outlines the basics of how to embed PDF in Excel, there are a few other options you can add on during this process to change how your PDF is displayed. Here, we’ll walk you through the process in more detail.
1. Before you embed PDF in Excel, you need to ensure the PDF you will be adding is closed. Once it is closed, open up the Excel document that you want to add the PDF to.
4. Select the PDF that you want to embed into your Excel file.
5. After selecting the file you want, you have the option to change the formatting before clicking 'OK'
6. To change the display of the icon within the Excel sheet, select ‘Change Icon’. Within this box, you can change the size and color of the icon and edit the name associated with the file.
7. Once done, select 'OK' on the bottom right.
3 ways inserting a PDF into Excel can improve your work.
There are many ways that embedding PDF in Excel can streamline your work.
- Convenience. If the information in your spreadsheet links to a particular resource in a PDF format, embedding the PDF in Excel will save the viewer from needing to search for the relevant file.
For example, if sending a bookkeeping Excel document to an accountant,attaching multiple PDF invoices to your spreadsheet can save time and reduce the number of files you need to send over. - To keep track of files. Many organisations need to keep an audit trail of when data was stored and updated. This can be done by embedding a PDF into Excel, then noting down the necessary information in the adjacent cells.
- To include more information. Sometimes there may not be enough room in the spreadsheet to include all the information you need. Or there may also be images you want to include. By learning to embed PDF in Excel, you can easily include more info or visuals directly in your spreadsheet, which prevents the user from having to exit it and locate another document.
FAQs.
Find the answers to the most common questions about inserting PDF files into Excel.
I got an error message when trying to insert PDF into Excel. What can I do?
If you receive an error message when trying to insert PDF into Excel, it could be that the PDF settings are preventing it from being able to be embedded. This is an Adobe Reader feature that is designed to protect the integrity of the PDF.
Can others open the PDF that I embedded in Excel?
If you have followed the above steps, then the PDF will become part of the package of the saved Excel file. This means that others will be able to open the PDF document too. If you went to Insert > Object > Package, then this won’t be the case.
Explore more Adobe Acrobat features and find out how you can add efficiency and organisation to your files.
More help with Acrobat content.
Get more out of Acrobat with our tips and guides.
https://www.adobe.com/uk/dc-shared/fragments/shared-fragments/interested-in/resources