Download Article
Download Article
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene has been writing and editing tech content at wikiHow since 2019. She previously worked for AppleCare, served as a writing tutor, volunteered in IT at an animal rescue, and taught as an adjunct professor for EN101 and EN102. Darlene has completed Coursera courses on technology, writing, and language. She holds both a BA (2011) and an MA (2012) from Rowan University in Writing, with a focus on workplace communication. With her extensive experience, academic background, and ongoing learning, Darlene has become the go-to grammar expert for her friends and family, as well as a skilled wordsmith for anyone in need.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 66,227 times.
Learn more...
Microsoft Excel allows you to include other files, such as Word documents and PDFs, into a spreadsheet. This wikiHow will show you how to insert a file as an object into an Excel project using OLE (object linking and embedding).
Adding an Object in an Excel Spreadsheet
- Select the cell where you want the object.
- Click the Insert tab.
- Select Object in the Text group.
- Click Create from File and then Browse.
- Find the file you want to add and click OK.
Steps
-
Open your project in Excel. You can open your project within Excel by clicking Open from the File tab, or you can right-click on the file in a file browser and click Open With and Excel.- This method works for newer versions of Excel on either PC or Mac.
-
Click the cell in which you want to insert the object. Whenever people view this cell, they will find the embedded document.Advertisement -
Click the Insert tab. You'll find this in the ribbon above the document editor or at the top of your screen. -
Click the icon that looks like a program window on a sheet of paper. This is the "Object" icon and can be found in the "Text" group. A box will pop up. -
Click the Create from File tab. The tab will switch from "Create New." -
Click Browse. Your file browser will open. -
7Navigate to and double-click your file. Only compatible files will show up in the browser, like PowerPoints, PDFs, and Word documents.[1]
-
Choose to select "Display as icon." If you select "Display as icon," you'll see the icon of the document appear in the cell; if you don't choose "Display as icon," the full first page of the document will appear. Regardless of your choice, both embedded documents will link to the full document. -
Click OK. You'll see this at the bottom right of the pop-up window. The document you selected will appear in the cell either as the full first-page document or icon.[2]
-
Open your project in Excel. You can open your project within Excel by clicking Open from the File tab, or you can right-click on the file in a file browser and click Open With and Excel.[3]- This method works for newer versions of Excel on either PC or Mac.
-
Click the cell you want to insert the object. -
Click the Insert tab. You'll find this in the ribbon above the document editor or at the top of your screen. -
Click the Pictures icon. You'll find this in the "Illustrations" group. A file browser will pop up. -
Navigate to and double-click on your image. The list of compatible file types is long, but all the common file types are accepted like GIF, JPG, and PNG.- The image is inserted into your document. You can edit the image using the Picture Tools tab.[4]
Expert Q&A
Tips
You Might Also Like
References
- ↑ https://support.microsoft.com/en-us/office/insert-picture-in-cell-in-excel-e9317aee-4294-49a3-875c-9dd95845bab0
- ↑ https://support.office.com/en-us/article/insert-an-object-in-your-excel-spreadsheet-e73867b2-2988-4116-8d85-f5769ea435ba
- ↑ https://support.office.com/en-us/article/insert-an-object-in-your-excel-spreadsheet-e73867b2-2988-4116-8d85-f5769ea435ba
- ↑ https://support.office.com/en-us/article/insert-an-object-in-your-excel-spreadsheet-e73867b2-2988-4116-8d85-f5769ea435ba
About This Article
1. Open your project in Excel.
2. Click the cell you want to insert the object.
3. Click the Object icon in the Insert tab.
4. Click the Create from File tab.
5. Click Browse and navigate to and double-click the file.
6. Choose to "Display as icon" or not.
7. Click OK.
Is this article up to date?
