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

Method 1 – Inserting an Image from Your Device:

Steps:

  • Select the desired cell (e.g., C5).
  • Go to the Insert tab.
  • Click the drop-down arrow under Illustrations and choose Pictures.
  • Select This Device.

Insert Image in Excel Cell As Attachment from Device

  • In the Insert Picture dialog box, choose the desired image (e.g., Google logo).
  • Click Insert.

  • The image is larger than the selected cell size.

  • To fit the image within the cell, go to the Picture Format tab:
    • Click the drop-down arrow under Align in the Arrange group.
    • Select Snap to Grid.

    Insert Image in Excel Cell As Attachment from Device

    • Resize the image as needed.

Insert Image in Excel Cell As Attachment from Device

  • Right-click the image and choose Size and Properties.

Insert Image in Excel Cell As Attachment from Device

  • In the Format Picture side window, under Size & Properties, select Move and size with cells.

Insert Image in Excel Cell As Attachment from Device

  • The image will insert inside the cell. If you insert a column or modify the column size, the image will move with the cell.
  • Repeat the process for other images.

Insert Image in Excel Cell As Attachment from Device

Read More: How to Insert Picture in Excel Cell Background


Method 2 – Inserting an Image as an Object:

  • Select the desired cell (e.g., C5).
  • Go to the Insert tab.
  • Click the drop-down arrow under Text and choose Object.

Insert Image in Excel Cell As Attachment as Object

  • In the Object dialog box:
    • Go to the Create from File tab.
    • Click Browse.

    Insert Image in Excel Cell As Attachment as Object

  • Another dialog box titled Browse will appear.
  • Choose the desired image (e.g., Google logo).
  • Click Insert.

  • The image location will appear in the “ile name box.
  • Click OK.

Insert Image in Excel Cell As Attachment as Object

  • To position the image precisely, go to the Shape Format tab:
    • Disable Snap to Grid from the drop-down under Align in the Arrange group.
  • Right-click the object and select Format Object.

Insert Image in Excel Cell As Attachment as Object

  • In the Format Object dialog box, under Properties, choose Move and size with cells.

  • Repeat for other images.

Insert Image in Excel Cell As Attachment as Object

  • To view an image, double-click it and use the Open Package Contents dialog.

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

Insert Image in Excel Cell As Attachment as Object

Read More: How to Insert Picture in Excel Cell Automatically


Method 3 – Inserting Data from Another Sheet as an Image:

In this method, we’ll demonstrate how to insert a dataset from another sheet as an image in Excel. There are two approaches: using the Copy as Picture feature and the Camera tool. Let’s consider sales data for the months of January and February, located in the cell ranges B4:C8 and E4:F8, respectively. Follow the steps below:


3.1 Copy as Picture and Insert Image as an 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.

Steps:

  • Begin by selecting the range of cells B4:C8.
  • In the Home tab, click the drop-down arrow next to Copy in the Clipboard group.
  • Choose Copy as Picture.

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

  • In the Copy Picture dialog box:
    • Select As shown on screen in the Appearance section.
    • Choose Picture in the Format section.
    • Click OK.

  • The dataset will be copied as an image.
  • Navigate to another sheet (e.g., the Copy-Paste sheet) and select cell C5.

  • 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 within the cell:
    • Go to the Picture Format tab.
    • Click the drop-down arrow next to Align in the Arrange group.
    • Select Snap to Grid.

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

  • Resize the image as needed.
  • Right-click the image and choose Size and Properties.

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

  • In the Format Picture side window:
    • Go to the Size & Properties tab.
    • Select Move and size with cells in the Properties section.

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

  • Repeat the process to insert the dataset for the month of February.

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

Read More:How to Insert a Picture in Excel Header


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

In this method, we’ll utilize Excel’s built-in Camera tool to insert a dataset as an image within an Excel cell. Follow these steps:

  • If the Camera tool isn’t in your Quick Access Toolbar:
    • Click on File > Options.

    • In the Excel Options dialog box, select Quick Access Toolbar.
    • Change Choose commands from to All Commands.
    • Scroll down and find the Camera command.
    • Add it to the toolbar.

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

    • Check Show Quick Access Toolbar and set the position to Above Ribbon.
    • Click OK.

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

  • Choose the range of cells (e.g., B4:C8).
  • Click the Camera tool in the Quick Access Toolbar.
  • The dataset will be selected.

  • Go to a new sheet (e.g., Camera).
  • Click on cell C5 to paste the image there.

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

  • To fit the image within the cell:
    • Go to the Picture Format tab.
    • Click the drop-down arrow next to Align in the Arrange group.
    • Select Snap to Grid.

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

    • Resize the image as needed.

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

  • Right-click the image and choose Size and Properties.

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

  • In the Format Picture side window:
    • Under the Size & Properties tab, select Move and size with cells.

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

  • Repeat for Other Datasets:
    • 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

 

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


Method 4 – Inserting an Online Image as an Attachment in an Excel Cell:

Now, let’s insert an image from online into an Excel cell as an attachment. We’ll use images from four institutions. Follow these steps:

  • Choose the desired cell (e.g., C5).
  • Go to the Insert tab.
  • Click the drop-down arrow next to Illustrations > Pictures.
  • Choose Online Pictures.

Insert Image in Excel Cell As Attachment from Online

  • In the Search box, type Google and press Enter.

  • Select your desired image (e.g., the 4th picture).
  • Click Insert.

Insert Image in Excel Cell As Attachment from Online

  • The image is far larger than our cell size.

  • To fit the image within the cell:
    • Go to the Picture Format tab.
    • Click the drop-down arrow next to Align in the Arrange group.
    • Select Snap to Grid.

Insert Image in Excel Cell As Attachment from Online

    • Resize the image as needed.
  • If needed, disable Snap to Grid and position the image according to your preference.

  • Right-click the image and choose Size and Properties.

Insert Image in Excel Cell As Attachment from Online

  • Under the Size & Properties tab, select Move and size with cells.

Insert Image in Excel Cell As Attachment from Online

  • Follow the same process to insert the remaining images.

Insert Image in Excel Cell As Attachment from Online

Read More: How to Insert Multiple Pictures at Once in Excel


Things to Remember

  • To ensure the image size changes with cell modifications:
    • Align all four edges of the image with the cell edge.
    • Even if you’ve selected the Move and size with cells option, proper alignment is crucial for resizing.

Download Practice Workbook

You can download the practice workbook from here:


Related Articles


<< Go Back to Excel Insert Pictures | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo