You are viewing a single comment's thread from:

RE: LeoThread 2025-02-08 08:07

in LeoFinancelast month

Part 4/6:

When embedding images, Google Sheets keeps the original aspect ratio by default, meaning the image will scale to fit the cell without distortions. However, you may want to modify this behavior. After the URL in your formula, you can add a comma followed by a different number to change how Google Sheets treats the image aspect ratio:

  • No number or blank: Keeps the original aspect ratio.

  • Number 2: Ignores the aspect ratio and stretches the image to fit the cell dimensions.

  • Number 3: Retains the image size regardless of the cell size.

For example, if you want to stretch an image, your formula would look like this:


=IMAGE("URL_HERE", 2)

This functionality provides flexibility when customizing how images appear based on your spreadsheet layout.