Download Article
A step-by-step guide to inserting objects in Excel
Download Article
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] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Advertisement
-
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] X Research source
Advertisement
-
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] X Research source
- 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] X Research source
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
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
Article Summary
X
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
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 61,968 times.
Advertisement