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.


Download Practice Workbook

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


4 Suitable Examples to Insert Image in Excel Cell as Attachment

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

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.

Insert Image in Excel Cell As Attachment from Device

  • 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.

Insert Image in Excel Cell As Attachment from Device

  • 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.

Insert Image in Excel Cell As Attachment from Device

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

Insert Image in Excel Cell As Attachment from Device

  • 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.

Insert Image in Excel Cell As Attachment from Device

  • 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.

Insert Image in Excel Cell As Attachment from Device

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

Read More: Excel VBA: Insert Picture from Folder (3 Methods)


2. Insert Image as Object

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.

Insert Image in Excel Cell As Attachment as Object

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

Insert Image in Excel Cell As Attachment as Object

  • 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.

Insert Image in Excel Cell As Attachment as Object

  • 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.

Insert Image in Excel Cell As Attachment as Object

  • 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.

Insert Image in Excel Cell As Attachment as Object

  • 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.

Insert Image in Excel Cell As Attachment as Object

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

Read More: How to Insert an Image into a Cell with Excel VBA (2 Methods)


Similar Readings


3. Inserting 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

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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

  • 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

  • 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

  • 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

  • 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

  • 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

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

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 ad 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

  • 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

  • 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

  • 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

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

Insert Data from Another Sheet as Image in Excel Cell As Attachment

  • 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

  • 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.

Insert Data from Another Sheet as Image in Excel Cell As Attachment

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

Read More: Insert Pictures in Excel Automatically Size to Fit Cells


4. Insert Image from Online

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.

Insert Image in Excel Cell As Attachment from Online

  • 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.

Insert Image in Excel Cell As Attachment from Online

  • 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.

Insert Image in Excel Cell As Attachment from Online

  • 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.

Insert Image in Excel Cell As Attachment from Online

  • 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.

Insert Image in Excel Cell As Attachment from Online

  • 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.

Insert Image in Excel Cell As Attachment from Online

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.

Read More: How to Fix Image in Excel Cell (2 Quick Solutions)


💬 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.


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.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo