PlayInfoBox

Home /Utilities /Fitting a Picture Exactly Inside a Cell in Excel

Fitting a Picture Exactly Inside a Cell in Excel

Tap a step below to see it explained in order.

  1. Insert the image

    Use Insert β†’ Pictures to add the image you want into the worksheet.

  2. Right-click the image and choose "Size and Properties"

    Right-click the inserted image and select Size and Properties.

  3. Choose "Move and size with cells"

    Under the Properties section, select Move and size with cells.

  4. Drag the image to match the cell size

    Drag the image's corner handles until it fits neatly inside the target cell.

  5. Why this is useful

    With this setting, the image automatically resizes along with the row height or column width whenever the table is edited later, keeping everything neat.

When you're managing a table of photos

Product catalogs, staff directories, and inventory sheets often need a photo embedded directly inside a row alongside its data. Setting the image to move and resize with its cell means the whole table stays visually consistent even after you adjust column widths or row heights later.

Keeping the proportions correct

By default, many images are set to a mode that doesn't move with the cell at all, so this setting needs to be changed manually every time. When resizing by dragging a corner, hold Shift to keep the image's original aspect ratio intact instead of letting it stretch or squash.

Frequently Asked Questions

Doesn't the image move with the cell by default?

No β€” the default is often set to something like "Don't move or size with cells," so you need to manually switch it to "Move and size with cells" for the image to follow the cell.

What if the image gets distorted when I resize it to fit a cell?

Hold the Shift key while dragging a corner handle. That keeps the original aspect ratio intact while resizing, avoiding any stretching or squashing.