Part 5/6:
Specifying Exact Dimensions
If you need more control over the image size, there’s a fourth option that allows you to specify exact dimensions. You’ll introduce width and height parameters:
=IMAGE("URL_HERE", 4, HEIGHT, WIDTH)
For instance, if you want an image to be 50 pixels high and 125 pixels wide, your formula would be:
=IMAGE("URL_HERE", 4, 50, 125)
Although this might not always yield a visually appealing result, it can be beneficial in specific use cases.
Autofill with Images
Interestingly, the IMAGE
function supports Google Sheets' autofill capability. If you have an image embedded in D2, you can use the fill handle (the small square at the bottom right of a selected cell) to drag down and replicate the same image in subsequent cells effortlessly.