Excel - Insert an image in a cell with image function Tutorial

In this video, you will learn how to insert an image in a cell using the image function in Excel.
The video demonstrates the process of specifying the URL of the image and adjusting its appearance in the cell.
This function is especially useful when working with data lists that contain URL links to different logos.
By using the image function, you can integrate logos directly into cells and even hide the column containing the URL.
This tutorial will help you enhance your Excel skills and improve your data visualization.

3:01
2762 views

Available in Microsoft365

Objectifs :

This document aims to provide a comprehensive guide on using the new IMAGE function in Excel, introduced in early 2023, to embed images directly into cells using URLs. It will cover the steps to implement this function, including setting alt text for accessibility and adjusting image display settings.

Chapitres :

Introduction to the IMAGE Function
In early 2023, Microsoft Excel introduced a new function called IMAGE, which allows users to embed images, logos, or photo objects directly into a cell. This function is particularly useful for enhancing the visual appeal of spreadsheets and making data more engaging.
Understanding the Function's Constraints
The IMAGE function has a key constraint: it requires a source URL that begins with the HTTPS protocol. This means that the images must be sourced from the internet. Users must copy the image link from their browser to retrieve the URL needed for the function.
Steps to Embed an Image in Excel
To use the IMAGE function, follow these steps: 1. **Copy the Image Link**: Right-click on the desired image in your browser and select 'Copy image link' to retrieve the URL. 2. **Insert the Function in Excel**: In your Excel file, use the IMAGE function by specifying the URL within quotation marks. For example: `=IMAGE("[URL]")`. 3. **Set Alt Text**: Optionally, you can add alt text for accessibility. For instance, use 'logo' as the alt text. 4. **Adjust Image Display Settings**: Choose how the image should appear in the cell by selecting options such as 'fit cell', 'fill cell', 'original size', or a customized size.
Using the IMAGE Function with URL Columns
If you have a table format with a column containing URLs to different logos, the IMAGE function can still be applied. The process is similar: - Specify the cell that contains the URL for the logo. - Set the alt text (optional). - Choose the integration mode to fit the logo automatically within the cell. The size of the logo will adjust based on the dimensions of the rows or columns.
Hiding URL Columns and Filtering with Alt Text
Once the logos are embedded, you can hide the column containing the URLs for a cleaner look. Additionally, the alt text can serve as a filter criterion. By clicking on the filter arrow, you can display a list of all alt text entries, allowing for easy filtering based on the associated image names.
Conclusion
The IMAGE function in Excel provides a powerful way to enhance your spreadsheets by embedding images directly into cells. By following the outlined steps, users can easily integrate logos and other images, set alt text for accessibility, and utilize filtering options to manage their data effectively. This functionality not only improves the visual presentation of data but also enhances user interaction with the spreadsheet.

FAQ :

What is the new image function in Excel?

The new image function in Excel allows users to embed images, logos, or photo objects directly into a cell using a URL. It was introduced at the beginning of 2023.

How do I use the image function in Excel?

To use the image function, copy the image link from your browser, then in Excel, use the function by specifying the URL in quotation marks. You can also set alt text and choose how the image should appear in the cell.

What types of settings can I apply when using the image function?

You can apply settings such as alt text for accessibility, and choose how the image fits in the cell, including options to fit cell, fill cell, use original size, or set a customized size.

Can I use the image function with a list of URLs?

Yes, if you have a column storing URL links to different logos, you can use the image function by referencing the cell that contains the URL, and the image will be retrieved accordingly.

What is the purpose of alt text in the image function?

Alt text serves as a description of the image for accessibility purposes. It can also be used as a filter criterion to sort or filter data based on the associated text.

Quelques cas d'usages :

Embedding Company Logos in Reports

Use the image function to embed company logos directly into Excel reports. This enhances the visual appeal and professionalism of the documents, making them more engaging for stakeholders.

Creating Dynamic Dashboards

Incorporate images dynamically into dashboards by linking to URLs. This allows for real-time updates of logos or images based on data changes, improving the relevance of the information presented.

Managing Product Catalogs

Utilize the image function to display product images in a catalog stored in Excel. By linking to image URLs, you can easily update product visuals without altering the catalog structure.

Enhancing Accessibility in Data Presentations

By using alt text with the image function, you can ensure that presentations are accessible to all users, including those with visual impairments, thereby promoting inclusivity in your data sharing.

Filtering Data by Image Description

Leverage the alt text feature to filter data based on image descriptions. This can be particularly useful in scenarios where you need to categorize or sort images based on specific criteria.

Glossaire :

Excel function

A predefined formula in Excel that performs calculations or operations on data. In this context, it refers to the new image function introduced in 2023.

Image function

A new function in Excel that allows users to embed an image, logo, or photo object directly into a cell using a URL.

URL

Uniform Resource Locator, a reference to a web resource that specifies its location on a computer network and a mechanism for retrieving it. In this case, it points to the location of an image on the internet.

HTTPS

Hypertext Transfer Protocol Secure, an extension of HTTP that uses encryption for secure communication over a computer network, commonly used for accessing websites.

Alt text

Alternative text that describes an image. It is used for accessibility purposes, allowing screen readers to convey the content of images to visually impaired users.

Fit cell

An option in the image function that adjusts the image size to fit the dimensions of the cell.

Fill cell

An option in the image function that stretches the image to fill the entire cell area.

Original size

An option in the image function that displays the image at its original dimensions without any resizing.

Customized size

An option in the image function that allows users to manually set the height and width of the image.

Table format

A structured format in Excel that organizes data into rows and columns, often used for data management and analysis.

00:00:02

At the beginning of 2023,

00:00:04

a new Excel function appeared.

00:00:06

This is the image function used to embed

00:00:09

in a cell a photo object, logo or image.

00:00:12

The constraint of the function,

00:00:14

as we will see shortly,

00:00:16

is that it is only available by looking

00:00:18

for a source pointing to a URL.

00:00:21

Starting with the HTTPS protocol,

00:00:24

typically an image that comes from

00:00:26

the Internet, the process is simple.

00:00:28

First copy the image link

00:00:30

through the browser.

00:00:32

For instance with a right click,

00:00:34

copy the image link to retrieve the URL.

00:00:37

In the Excel file you can then through

00:00:40

the image function specify the URL,

00:00:42

then add quotation marks on both sides.

00:00:46

Do not leave those out,

00:00:47

and I can also apply other settings such

00:00:50

as alt text for accessibility issues.

00:00:53

Here I will use as an example the word logo.

00:00:56

Then I'll specify how this logo

00:00:59

should appear in the cell.

00:01:00

I can pick fit cell,

00:01:03

fill cell,

00:01:04

use its original size or customized size.

00:01:07

The last option lets me adjust

00:01:09

to height and width.

00:01:11

Let's keep it simple and ask Excel to

00:01:14

automatically fill the cell by adjusting

00:01:16

it directly to the image we insert.

00:01:18

I will now select zero mode.

00:01:20

I close the parenthesis.

00:01:22

My image appears in my cell.

00:01:27

Note selecting the cell reveals

00:01:29

the calculation formula that

00:01:31

helped us retrieve this image.

00:01:34

In the event you have applied table

00:01:36

format and have created a column

00:01:38

storing URL links to different

00:01:40

logos including your data list,

00:01:42

the function works here too.

00:01:44

The process remains the same.

00:01:46

Image the source will be the

00:01:48

cell that contains the full

00:01:50

URL to access the desired logo,

00:01:52

specifying the alt text which is optional,

00:01:56

and the integration mode.

00:01:57

Where I will specify once more to fit

00:02:00

the cell to the logo automatically

00:02:02

the logo is retrieved through the

00:02:04

URL stored in my column G the size

00:02:07

of the logo will vary automatically

00:02:13

Depending on the size I

00:02:15

assign to my rows or columns.

00:02:20

And I can finish why not by hiding

00:02:22

the column containing the URL of

00:02:24

the logo through the image function,

00:02:27

I was able to integrate a

00:02:29

logo directly in the cell.

00:02:31

The optional Atl text can also be

00:02:33

used as a filter criterion and here

00:02:36

when we click on the filter arrow,

00:02:39

it displays the list of all text,

00:02:41

in this case the three cells

00:02:43

containing the logos

00:02:44

The alt text is logo because

00:02:47

I only have one item,

00:02:49

but if I customize the alt

00:02:51

text name line by line,

00:02:53

I can use the image name to

00:02:55

filter my lines based on the alt

00:02:58

text associated with each image.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2496 Views

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivo...

ALL COURSES