1 - fill the cell with the image ignoring its aspect ratio.0 (default) - fit the picture in the cell maintaining its aspect ratio.Sizing (optional) - defines the image dimensions. Can be supplied in the form of a text string enclosed in double quotes or as a reference to the cell containing the URL.Īlt_text (optional) - the alternative text describing the picture. Source (required) - the URL path to the image file that uses the 'https' protocol. The function takes a total of 5 arguments, of which only the first one is required. The following file formats are supported: BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP. The IMAGE function in Excel is designed to insert pictures into cells from a URL. Return an image based on another cell value.How to insert picture in cell with formula - examples.Instead of floating on top of a spreadsheet, your images are now its integral part. With the newly introduced IMAGE function, you can insert a picture in a cell with a simple formula, place images within Excel tables, move, copy, resize, sort and filter cells with pictures just like normal cells. Microsoft Excel users have inserted pictures into worksheets for years, but that required quite a lot of effort and patience. Learn a new amazingly simple way to insert a picture into a cell by using the IMAGE function.