How to Insert Image in Excel Cell as Attachment (4 Examples)

Inserting images in Excel is a common task for everyone. We add an image in Excel for a different purpose. In this article, we will show four suitable examples of how to insert an image in the Excel cell as an attachment. If you are curious about it, download our practice workbook and follow us.

To demonstrate the examples, we are going to insert some institutions’ logos and images into our dataset as an attachment. Moreover, we will show you the procedure to insert a dataset as an image in an Excel cell as an attachment.

1. Inserting Image from Device into Excel Cell as Attachment

In the first example, we will insert the image in the Excel cell as an attachment from our device. We are going to insert four institutions’ logos into our dataset. The steps to complete this task are given below:

📌 Steps:

First of all, select cell C5.
Now, in the Insert tab, click on the drop-down arrow of the Illustrations > Pictures option.
Then, choose the This Device option.

As a result, a small dialog box called the Insert Picture will appear.
Choose the image according to your desire. In our case, we select the logo of Google.
Finally, click the Insert button.

You may notice that the image is far large than our cell size.

To fit the image inside the cell, go to the Picture Format tab and select the drop-down arrow of the Align option from the Arrange group.
Now, select the Snap to Grid option.

After that, select the Resize icon at the bottom corner and drag the mouse upward to reduce the image size.
You will see when the image edge coincides with the cell edge you won’t be able to reduce the image size further.

Then, right-click on the image and choose the Size and Properties option.

As a result, a side window called Format Picture will appear on the right side of the screen.
After that, in the Size & Properties tab, select the Move and size with cells option from the Properties section.

The image will insert inside the cell. Now, if you insert a column or modify the column size, the image will move with the cell.
Similarly, follow the same process to insert the rest of the image.

Thus, we can say that our method worked perfectly, and we are able to insert an image in the Excel cell as an attachment.

2. Inserting Image as Object in Excel Cell as Attachment

In this example, we are going to insert the image in the Excel cell as an attachment from the Object command. We will insert those four institutions’ logos into our dataset again. The steps to complete this task are given as follows:

📌 Steps:

At first, select cell C5.
After that, in the Insert tab, click on the drop-down arrow of the Text option and choose the Object command.

As a result, a small dialog box called the Object will appear.
Now, go to the Create from File tab and click on Browse.

Another dialog box titled Browse will appear.
Choose the image according to your desire. In our case, we select the logo of Google.
At last, click the Insert button.

The image location will show in the File name box.
Finally, click OK.

You will get the image inside the cell.
To position the image perfectly inside the cell, go to the Shape Format tab and disable the Snap to Grid command from the drop-down of the Align option, located in the Arrange group.
Now, right-click on the object and select the Format Object option.

As a result, a small dialog box entitled Format Object will appear.
Now, in the Properties tab, choose the Move and size with cells option from the Object positioning section and click OK.

Similarly, follow the same process to insert the rest of the image.

To show the image, double-click on any image.
As a result, a small dialog box called Open Package Contents will appear.
Then, click on Open.

You will be able to see the image through the image viewer of your device.

Finally, we can say that our method worked effectively, and we were able to insert an image in the Excel cell as an attachment.

3. Entering Data from Another Sheet as Image

Here, we are going to insert a dataset as an image from another sheet. We can complete the job in two ways. The first one is the Copy as Picture feature, and the second option is using the Camera tool. To demonstrate the methods, consider the dataset of sales for the month of January and February. The datasets are in the range of cells B4:C8 and E4:F8. We will demonstrate both approaches below.

3.1 Copy as Picture and the Insert Image as Attachment

Here, we will show the process of copying a dataset as an image in Excel and inserting it in a cell as an attachment. The procedure is explained below:

📌 Steps:

In the beginning, select the range of cells B4:C8.
Now, in the Home tab, click on the drop-down arrow of the Copy option from the Clipboard group.
Then, choose the Copy as Picture option.

As a result, a small dialog box called Copy Picture will appear.
Choose the As shown on screen option in the Appearance section and the Picture option from the Format section.
Finally, click OK.

The dataset will copy as an image.
Now, go to another sheet. In our workbook, we go to the sheet titled Copy-Paste and select cell C5.

Then, press ‘Ctrl+V’ to paste the image into that cell.

To fit the image inside the cell, go to the Picture Format tab and select the drop-down arrow of the Align option from the Arrange group.
After that, select the Snap to Grid option.

Then, select the Resize icon at the bottom corner and drag the mouse to resize the image.
You will see when the image edge coincides with the cell edge you won’t be able to reduce the image size further.
Now, right-click on the image and choose the Size and Properties option.

As a result, a side window called Format Picture will appear on the right side of the screen.
Then, in the Size & Properties tab, select the Move and size with cells option from the Properties section.

The image will insert inside the cell. Now, if you insert a column or modify the column size, the image will move with the cell.
Similarly, follow the same process to insert the dataset for the month of February.

So, we can say that our method worked precisely, and we were able to insert an image in the Excel cell as an attachment.

3.2 Using Camera Tool to Insert Image in Excel Cell as Attachment

In the following method, we will use the Excel built-in Camera tool to insert the dataset as an image in the Excel cell as an attachment. The steps of this approach are given as follows.

📌 Steps:

First of all, if you don’t have the Camera tool in your Quick Access Toolbar, then you have to enable it.
For that, click on File > Options.

As a result, the Excel Options dialog box will appear on your device.
Now, click on the Quick Access Toolbar option.
Then, change the Choose commands from option Popular Commands to All Commands.
You will get all Excel commands in the command box.
Scroll down with your mouse and find out the Camera command.
After that, select the Camera command and click on Add option.

Afterward, check the Show Quick Access Toolbar option and set the Toolbar position at Above Ribbon.
Finally, click OK.

You will see the Camera tool above the built-in Excel ribbon.

Now, select the range of cells B4:C8.
Then, click on the Camera tool from the Quick Access Toolbar.
You will see the dataset is get selected.

Afterward, go to another new sheet. In our workbook, we go to the sheet titled Camera.
Click on cell C5, and you will get the image on that sheet.

If the image doesn’t insert at your desired cell, then go to the Picture Format tab and select the drop-down arrow of the Align option from the Arrange group.
Next, select the Snap to Grid option.

Then, place the image in your desired cell.
Select the Resize icon at the bottom corner and drag the mouse to resize the image and coincide the image edge with the cell edge.

At last, right-click on the image and choose the Size and Properties option.

As a result, a side window called Format Picture will appear on the right side of the screen.
Now, in the Size & Properties tab, select the Move and size with cells option from the Properties section.

The image will insert inside the cell. Now, if you insert a column or modify the column size, the image will move with the cell.
Similarly, follow the same process to insert the dataset for the month of February.

Hence, we can say that our method worked perfectly, and we were able to insert an image in the Excel cell as an attachment.

4. Insert Image from Online as Attachment in Excel Cell

Now, we will insert the image in the Excel cell as an attachment from online. We are going to insert four institutions’ images. The step-by-step procedure to complete this task is given below:

📌 Steps:

First, select cell C5.
Now, in the Insert tab, click on the drop-down arrow of the Illustrations > Pictures option.
Then, choose the Online Pictures option.

As a result, a dialog box called the Online Pictures will appear.
After that, in the Search box, write down Google and press Enter.

Within a second, some pictures of Google will appear in front of you. Choose your desired one. We choose the 4th picture.
Finally, click on the Insert button.

It may take a while to download the image and show it in the cell.
You may notice that the image is far large than our cell size.

To fit the image inside the cell, go to the Picture Format tab and select the drop-down arrow of the Align option from the Arrange group.
Next, select the Snap to Grid option.

After that, select the Resize icon at the bottom corner and drag the mouse upward to reduce the image size.
You will see when the image edge coincides with the cell edge you won’t be able to reduce the image size further.
If you need to position the image in a large cell, disable the Snap to Grid option and keep the picture according to your desired position.

Now, right-click on the image and choose the Size and Properties option.

As a result, a side window called Format Picture will appear on the right side of the screen.
Then, in the Size & Properties tab, select the Move and size with cells option from the Properties section.

The image will insert inside the cell. Now, if you insert a column or modify the column size, the image will move with the cell.
Similarly, follow the same process to insert the rest of the image.

At last, we can say that our method worked successfully, and we were able to insert an image in the Excel cell as an attachment.

💬 Things to Remember

To increase or decrease the image size with the modification of the cell size, you have to coincide all the four edges of the image with the cell edge. Although you have selected the Move and size with cells option, if the edges don’t keep one above another, the image size will not change.

Download Practice Workbook

Download this practice workbook for practice while you are reading this article.

Insert Image in Cell as Attachment.xlsx

Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to insert an image in the Excel cell as an attachment. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

<< Go Back to Excel Insert Pictures | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

How to Insert Image in Excel Cell as Attachment (4 Examples)

1. Inserting Image from Device into Excel Cell as Attachment

2. Inserting Image as Object in Excel Cell as Attachment

3. Entering Data from Another Sheet as Image

3.1 Copy as Picture and the Insert Image as Attachment

3.2 Using Camera Tool to Insert Image in Excel Cell as Attachment

4. Insert Image from Online as Attachment in Excel Cell

💬 Things to Remember

Conclusion

Related Articles

Leave a reply Cancel reply