Microsoft Excel Now Has an IMAGE() Function
Microsoft Excel has supported inserting images into spreadsheets for years, but they floated above the sheet instead of appearing in cells. That’s finally changing.
Microsoft is now testing a new function in Excel, called IMAGE, which returns an image within a cell. Unlike the existing method of inserting an image (from the Insert tab), the new function keeps the image inside the cell, so it can stay in its intended place as you adjust rows and columns.
The new IMAGE function imports an image from a specified URL, which can be in BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, or WebP format. You can optionally set an alt text (alternative text) value, which is helpful for screen readers and other accessibility tools. The width and height can be defined in pixels, or you can pick from three other options — fit the image with its aspect ratio, fit the image ignoring the aspect ratio, or maintain the original size (which could exceed the cell boundary).
=IMAGE(source, [alt_text], [sizing], [height], [width])
Read Full Article Source