If you are looking for how to open an embedded file in Excel, then you are in the right place. We need to use an embedded file for different purposes while using Excel. In this article, we’ll try to discuss how to open an embedded file in Excel.
How to Open Embedded File in Excel: Step-by-Step Procedures
Excel offers easy ways to open an embedded file in Excel. We just need to follow some simple steps.
1. Opening a New Workbook
To open an embedded file we need a platform where we can open it. As our task is to open it in an Excel File, we need an Excel file before doing anything. Again, an Excel file has lots of cells. But we have to open the embedded file in one specific file.
So, firstly, open a new workbook like this.
Here, we have stated the title and hidden the gridlines for a better look, you may or may not choose to do the similar.
2. Working with Insert Feature
In this step, firstly, select a cell where we want to open the embedded file. In this case, it is B4.
Secondly, go to Insert > select Text > choose Object.
Here, we have selected the Text option because the file has a name that is in text format. Under the Text option, we have selected Object because the embedded file acts like an object in a cell.
3. Browsing an Existing File
In this step, we need to browse the file which we want to embed. This file needs to be on your PC. After choosing Object, eventually, a window named Object will appear.
Then, go to Create from File > select Browse.
Secondly, select the file from the specified location and click Insert.
Thirdly, make sure that Link to File and Display as Icon are selected. Link to File needs to be selected because we want the embedded file to be linked to its original location. And if we select Display as Icon the embedded file will remain as an icon in the selected cell.
Lastly, click OK.
Consequently, the embedded file will be like this.
Now, whenever you want to open that file just click on the icon, and it will appear in front of you.
Read More: How to Use Excel Objects to Create an Art Portfolio
How to Open Embedded PDF in Excel
Similar to an Excel file, we can also open an embedded PDF file easily in Excel. The procedure is pretty much identical to what we have just seen in the earlier section.
Steps:
Firstly, open a new worksheet.
Secondly, select cell B4.
Thirdly, select Insert > choose Text > pick Object.
Immediately, an Object window will appear.
Thirdly, go to Create from File > select Browse.
Now, select the PDF file from the specified location > click Insert.
Again, make sure that Link to File and Display as Icon are selected.
Lastly, click OK.
Finally, we will have the embedded PDF file like this.
Download Practice Workbook
Conclusion
That’s all about today’s session. These are the ways to open an embedded file in Excel. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section.
<< Go Back to Attach File in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
