The popular spreadsheet application is famous for its computing formula, but with this feature, you can sort, filter, calculate, and write formulas with pictures. There are a few possibilities that come with this formula, which also works in the Safe mode. You can fit the picture in the cell and maintain its aspect ratio or ignore it, maintain the original size which could exceed the cell boundary, or customize the height and the width. Read along to find out how to do so in Excel.
How to insert images into cells in Microsoft Excel.
1 With your Microsoft Excel opens, type =IMAGE(source, [alt_text], [sizing], [height], [width]) into the desired cell. Please be mindful that the function requires a web source location (BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP files with an HTTP protocol are supported). 2. Replace source with the web location, [alt_text] with the alt text, and so on. However, it’s worth noticing that the URL limit is set to just 255 characters, you can do a workaround of it by putting the image link in another cell and then referencing that cell as a source. Have you ever used this feature? Let us know in the comments!
SPONSORED
Name *
Email *
Commenting as . Not you?
Save information for future comments
Comment
Δ
