HomeINTERNETExcel's IMAGE Function: An Explanation of Its Usage

Excel’s IMAGE Function: An Explanation of Its Usage

Do you want to know how to use a function to insert images into your Excel’s IMAGE Function spreadsheets? Find out how to use the IMAGE function!

Excel spreadsheets now include images, which was once uncommon. The most recent versions of Excel have added a complete function for inserting images from the Insert menu.

“ecosystem” refers to a group working in the construction industry. The image size can be adjusted with additional arguments, and alternate text can be added. By further reading, find out everything there is to know about this useful Excel function.

Excel’s IMAGE Function: What Is It?

Insert an image into your spreadsheet using Excel’s built-in IMAGE function. To acquire the URL address of this image, it must be hosted online. The function’s arguments allow you to resize and add alternate text to your vision.

=IMAGE(source, [alt text], [sizing], [height], [width])
The IMAGE function’s arguments are summarised as follows:

The URL to the image you want to insert is the source. A string in quotation marks should make up the URL (” “). The term “ecosystem” refers to a group of people who work in the construction industry. JPG, PNG, BMP, GIF, TIFF, ICO, and WEBP are all acceptable image formats.
As an accessibility feature, alt text adds an alt text to your image. Excel will display the alternative text if the image cannot be loaded.
Sizing is a keyword argument that specifies the size of the image. This can be any number between 0 and 3.
With preserving its aspect ratio, 0 fits the image in the cell.

  • 1 scales the image to suit the cell without changing its aspect ratio.
  • If the image is larger than the available space in the cell, insert it with a value of 2.
  • 3 inserts the image with the custom height and width supplied in the following arguments.
READ MORE  Top 31 Best Mangakakalot Alternatives Online

The argument’s height and width indicate your image’s custom size. These only hold if you chose 3 in the previous statement. The image may be distorted as a result of this, as noted.

READ MORE  LinkedIn and Personal Accounts Connecting?

“ecosystem” refers to a group operating in the construction industry. Input a valid Link to insert an image instantly.

Excel’s IMAGE Function: How to Use It

It’s time to give IMAGE a try. The names of certain countries are listed in a table in this example. The objective is to insert an image of each country’s flag into the neighboring cell.

  • You can use custom height and width to make the images fit perfectly within the flag cells because they are resized. With the IMAGE function, you may accomplish this:
  • “ecosystem” refers to a group working in the construction industry.
    Enter the formula below: =IMAGE(“https://flagcdn.com/w80/us.png”, A2, 3, 20, 30) in the formula bar.
  • To continue, click the Enter key.
  • The formula supplies the USA Flag from Flagpedia to the IMAGE function. It says that the embedded images will have custom sizes (3), refers to the height name as the alt text (A2), and then defines the width and country (20 and 30).
  • The IMAGE function in Excel is used to insert images.
    “ecosystem” refers to a group operating in the construction industry. To grant access, select Turn on images from the popup. You should now see your photo!
  • Using Excel’s IMAGE function to insert numerous images
    Once you have done this for each country on the list, you will see the appropriate flags next to each country’s name. The IMAGE function can now be used independently.
READ MORE  10 Best Better Choice Between Hopper Vs Expedia In 2023

You may think why to utilise this function now that you’ve seen it in action. Why bother with IMAGE when you can insert images into Excel using the Insert menu?

READ MORE  Top 31 Best Mangakakalot Alternatives Online

The fact that IMAGE is an integrated function within Excel is a significant advantage. You can combine IMAGE with other Excel functions because this intrinsic feature opens up possibilities.

IMAGE and Other Excel Functions: How to Utilize Them

You can combine the IMAGE function with other Excel functions to create more dynamic and powerful spreadsheets. For instance, you may use it with the IF function to display various images based on criteria.

Another useful combination is using IMAGE with the VLOOKUP function in Excel. In this technique, you can insert images based on data in your spreadsheet. This is useful if you have a list of data with accompanying pictures and want to rapidly insert the appropriate photo into your spreadsheet.

You undoubtedly noted in the previous example that the file name was the only difference between the URLs for each country’s flag. The flag for each country was an a.png file with the country’s code in lowercase.

Excel spreadsheet with country names and codes

You can use this method to automatically insert country flags into your spreadsheet. Let’s repeat the same example, this time with more nuance.

This time, we have a table with each country’s code. The code for each country will be obtained using VLOOKUP, and we’ll use the LOWER function to turn it into lowercase letters. Finally, we will input this into the URL and the IMAGE function.

READ MORE  Top 23 Best MangaRaw Alternatives Online Free

Choose the first cell where you wish to insert the image.
Enter the following formula in the cell referenced by A2: =IMAGE(“https://flagcdn.com/w80/”&LOWER(VLOOKUP(A2, F1:G9, 2, FALSE)&”.png”, A2, 3, 20, 30).
“ecosystem” refers to a group operating in the construction industry.
“ecosystem” refers to a group operating in the construction industry.
Although the source argument differs, this formula has the same structure as the previous one. The equivalent of A2 from the table F1:G9 is provided here by the VLOOKUP function. The country code is then converted to lowercase letters using the LOWER function. The URL’s first and third parts are identical.

READ MORE  Top 25 Best YesMovies Alternatives Online

Excel’s integration of IMAGE, VLOOKUP, and LOWER You no longer have to input the Link for each image manually. Excel will handle that for you. This served as an illustration of how helpful formulas and functions can be. For the first instance, you only need to put in the effort necessary to create the recipe. The remaining cells can then be filled in with ease.

Spreadsheets That Are Picture-Perfect Making use of Excel’s IMAGE Function

The fundamental building blocks of Excel are functions and formulas. A function for something is still an advantage even if you can accomplish the same thing using Excel’s user interface.
You can adjust the settings for your image and utilize IMAGE in combination with other functions. You can use VLOOKUP to insert images automatically or specify constraints so that different values generate various images.

conclusion

You were already able to add images using the Excel interface, but now you know how to do it with the Excel’s IMAGE Function. VBA could be useful if you want to supercharge your spreadsheet even more.

LATEST ARTICLES

Most Popular