The new feature Image in a cell Excel 365 allows you to use images as values.

1. Import one or more images into cells in one action. The image import technique is really very clever and allows you to import multiple images into multiple cells.
2. Adjust the image size. With this new import mode, images adapt to the cell size.
3. Alternative text. You can assign text to each image to make it easier to identify in your workbook.

Import images into Excel cells

To add one or more images to a cell, simply go to the menu Insert > Image > Place in Cell. That's all the difference

• Place in cell will use theimage as value
• Place on one the cells will be a simple image that you will be able to crop, change the coloring, the hue.....

Note that you can retrieve your images from several sources, computer, web or even from your mobile. Here we will load all of our employee images, each image into a cell. All images are fictitious and are generated using this website.

1. Go to the menu Insert > Image > Place in Cell > This Device
2. Select multiple images from the same folder
3. Excel will insert each image into a specific cell

Image size is related to cell size.

Once the image is in the cell, it is easy to enlarge the image by changing the height or width of the cells

Toggle Picture as value / Picture to edit mode

You can change the way images are used by clicking the following icon. This icon is automatically displayed when you select the cell with the image.

After clicking on this icon, the image is editable and editable

Add Alt Text to Your Images

To “identify” your images, you can add an alternative text ; better known as alt Text in the web world. To add alt text, simply right-click on the image and select Show Alt Text.

Then, in the pane that appears, you write the attribute you want to give to the image.

It's only because you assign alt text to your images that you can filter themWithout this, you would only have the term "Image" visible in the filter choices.

Macro to update Alt Text of images

The problem is that to assign alt text to each image, you have to do it one by one. But you can also do it by using the following code which will assign the employee's name in column A as Alt Text.

In this situation, it is necessary that

• The name to be assigned is in column A
• The image in column B

Sub Update_AltText()
Dim i As Long
    For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row - 1
        Cells(i + 1, 2).UpdatePictureInCellAlternativeText AlternativeText:=Cells(i + 1, 1)
    Next
End Sub

Related Articles

• The PICTURE function in Excel
• How to use the IMAGE function with SharePoint URLs
• Use images in your Excel formulas
• Add images to a TCD
• Use Excel as a Google Image Search Engine
• Word cloud in Excel