How to Resize Images in Google Sheets

Images in Google Sheets don't all behave the same way. Drag a handle and nothing happens. Type exact pixel values and the image ignores them. The reason is that how you inserted the image controls how you resize it.

This guide shows you how to resize images in Google Sheets, whichever method you used to insert them.

Table of Contents

Prerequisites

A Google account with access to Google Sheets
A spreadsheet with at least one image already inserted (or a public image URL if using the IMAGE formula)

Resizing Images Inserted with the IMAGE Formula

The IMAGE formula lets you control image size directly in the formula itself, using width and height parameters.

When to use: Use this when your image is loaded from a URL and you want to control its size without touching the row or column manually.

Steps:

Click the cell where you want to insert the image.
Type the formula using this syntax:
```
=IMAGE(url, mode, height, width)
```
A real working example:
```
=IMAGE("https://www.example.com/photo.jpg", 4, 150, 300)
```
This displays the image at exactly 150px tall and 300px wide.
Press Enter to confirm.

Note: The height and width parameters only work when mode is set to 4. For all other modes, those parameters are ignored.

Result: The image appears in the cell, sized according to the mode you selected.

Limitations:

The image must be publicly accessible via URL. Private Drive links won't work unless shared publicly.
You can't drag the image or resize it with handles. All sizing is controlled through the formula.

Understanding All Four IMAGE Modes

The mode argument changes how the image scales inside the cell.

Mode	Behaviour	Respects Aspect Ratio	Exact Pixel Control
1 (default)	Fits image inside cell, maintains aspect ratio	✅ Yes	❌ No
2	Stretches image to fill the cell	❌ No	❌ No
3	Displays image at its original size	✅ Yes	❌ No
4	Uses custom height and width values	✅ Yes (if you set it correctly)	✅ Yes

Mode 4 is the only mode that lets you set exact pixel dimensions. Always pair it with both a height and width value in the formula.

Resizing Floating Images (Inserted via Insert > Image)

You can resize a floating image by dragging its handles or by entering exact dimensions in the Image Options panel.

When to use: Use this when you inserted the image via Insert > Image > Insert image over cells and it sits on top of the grid rather than inside a cell.

Steps:

Click the image to select it. Blue handles appear around the edges and corners.
To resize by dragging, click and drag any corner or edge handle.

Important: Dragging a corner handle keeps the aspect ratio locked. Dragging a side handle stretches only one dimension and will distort the image.
To resize with exact dimensions, right-click the image and select Image options. In the panel that opens, enter your target width and height in pixels.

Image: The Image options panel open in the right sidebar, showing width and height input fields for a selected floating image.
Press Tab or click outside the field to apply.

Result: The image is resized to the dimensions you specified.

Limitations:

There's no aspect ratio lock in the Image Options panel. If you change only one dimension, the image will distort. Change both width and height together, keeping the same ratio.
Floating images move if rows or columns are added above or to the left of them. They are not anchored to a cell.

Resizing In-Cell Images (Inserted via Insert > Image in Cell)

In-cell images resize when you change the row height or column width of the cell they occupy.

When to use: Use this when you inserted the image via Insert > Image > Insert image in cell and the image is locked inside a specific cell.

Steps:

Hover over the row number on the left until the cursor becomes a double-headed arrow.
Click and drag the row border up or down to change the row height.

Image: A Google Sheets row border being dragged to increase row height, with an in-cell image visible inside the row.
To set an exact row height, right-click the row number and select Resize row. Enter a pixel value and click OK.

Image: The Resize row dialog in Google Sheets with a pixel value entered in the height field.
Repeat for the column width if you need the image to scale horizontally. Right-click the column letter and select Resize column.

Result: The image scales to fill the resized cell.

Limitations:

There are no drag handles on in-cell images. You cannot resize the image directly.
The image always fills the cell. You can't set an independent size for the image separate from the cell dimensions.
Changing the row height affects every cell in that row, not just the one with the image.

Resizing Multiple Images at Once Using Drive Explorer Pro

Drive Explorer Pro lets you insert images from Google Drive into Sheets with a built-in resize option, so every image lands at the same dimensions without manual adjustment.

When to use: Use this when you're inserting many images from Google Drive into a spreadsheet and need them all at a consistent size. This saves you from resizing each image one by one after insertion.

Steps:

Open Google Sheets and go to Extensions > Drive Explorer Pro.
The Drive Explorer Pro sidebar opens. Navigate to the folder containing your images.
Select the images you want to insert.
Before inserting, open the Settings tab and set your target image width and height.
Switch back to the List Files tab and click Insert. The images are inserted into the sheet at the dimensions you set.

Result: All selected images appear in your sheet at a consistent, pre-set size.

Limitations:

Drive Explorer Pro works with images stored in Google Drive. Images hosted on external URLs use the IMAGE formula instead.

Try Drive Explorer Pro Drive Explorer Pro lets you list, filter, and insert Google Drive images directly into Google Sheets with a built-in resize option — no code needed. Install it free from the Google Workspace Marketplace.

Comparing Image Resize Methods

Feature	IMAGE Formula	Floating Image	In-Cell Image	Drive Explorer Pro
Supports exact pixel dimensions	✅ Yes (mode 4)	✅ Yes	❌ No	✅ Yes
Maintains aspect ratio	✅ Yes	⚠️ Manually	✅ Yes	✅ Yes
Works in bulk	❌ No	❌ No	❌ No	✅ Yes
Formula-based	✅ Yes	❌ No	❌ No	❌ No
Drag-to-resize available	❌ No	✅ Yes	❌ No	❌ No

Choosing the Right Method

Method	Best For
IMAGE formula	Single images loaded from a public URL
Floating image	Manual sizing of one image, precise pixel control
In-cell image	Images that should stay anchored inside a cell
Drive Explorer Pro	Bulk inserting many Drive images at a consistent size

Conclusion

Each image type in Google Sheets has its own resize rules. The IMAGE formula uses mode 4 for pixel-exact sizing. Floating images use drag handles or the Image Options panel. In-cell images resize with the row or column. For inserting many images at once at a set size, Drive Explorer Pro removes the manual work entirely.

Try Drive Explorer Pro Drive Explorer Pro lets you list, filter, and insert Google Drive images directly into Google Sheets with a built-in resize option — no code needed. Install it free from the Google Workspace Marketplace.