How to Insert Image in Excel Cell: Anchor, Lock, and Resize Pictures

Floating vs. Anchored Images in Excel

When you insert an image in Excel, it doesn't land inside the cell — it floats above the grid like a sticker on glass. That's fine for simple layouts, but it causes real headaches when you sort rows, filter data, or resize columns. The image just sits there, covering whatever's underneath it. And the bigger the sheet, the worse this gets.

What you actually want is an image anchored to a cell — one that moves and resizes when the row or column does. You've probably seen this in product catalogs or employee directories: each photo stays glued to its row, moves when you sort by name, and disappears with the row when you apply a filter. That behavior doesn't happen by default. You have to enable it — and it's a setting that's easy to miss the first time around.

There are two ways to get there: the classic approach that works in all versions (insert then change the Properties setting), and the newer "Place in Cell" feature in Excel 365 that does it in one step. Both work well — the right choice depends on your Excel version and whether you need precise control over image crop and fit.

If you use data analysis in Excel heavily — think product catalogs, ID databases, or dashboards with embedded logos — getting images locked to cells will save you a lot of frustration. Once you know the anchoring trick, it takes about 20 seconds per image. The tricky part is just knowing where the setting lives.

Method 1: Insert > Pictures + Anchor to Cell (All Versions)

This method works in Excel 2016, 2019, 2021, 365, and Mac. It's a two-step process: first you insert the image as a floating object, then you change one property setting to lock it to the cell. Takes about 30 seconds once you know where the setting lives.

Step 1 — Insert the image

Click the cell where you want the image to live. Go to the Insert tab, click Pictures, then choose This Device (or Picture From File on older versions). Browse to your image — JPG, PNG, GIF, BMP, TIFF, and SVG are all supported — and click Insert.

The image lands on the sheet as a floating object. You'll see selection handles around it. Don't panic that it's not inside the cell; that's expected. Excel places large images near the top-left of the visible screen, so scroll to find it if your target cell was elsewhere. If you have a very large image, Excel may scale it down automatically to fit the current view — that's fine, you'll resize it yourself in the next step.

Step 2 — Resize the image to fit the cell

Before anchoring, size the image so it fits within your target cell. Drag the corner handles (hold Shift to maintain aspect ratio) until the image matches the cell's borders. You can also right-click the image, choose Size and Properties, and type exact dimensions. If you need to change column width in Excel to give the image more room, do that first — it's easier to resize the column once than to manually resize every image.

Pro tip: hold Alt while dragging the image and it will snap to cell borders automatically. This makes precise alignment much faster, especially when working with uniform product photo grids where every cell needs to match. If the image is in a data row and you're also using how to indent in Excel for text labels in adjacent cells, get your column widths right before inserting any images.

Step 3 — Anchor the image to the cell

This is the key step that most users miss entirely, and it's the one that makes all the difference. Right-click the image and select Format Picture. In the panel that opens on the right, click the Size & Properties icon — it's the fourth icon in the row, looks like a small rectangle with directional arrows. Click to expand the Properties section. You'll see three radio button options:

• Move and size with cells — image moves AND resizes when the row/column changes. Best for most use cases.
• Move but don't size with cells — image moves with the row but keeps its original dimensions.
• Don't move or size with cells — image is fully floating, ignores cell changes. This is the default.

Select Move and size with cells and close the pane. If you're building a large catalog with dozens of images, repeat these steps for each image. You'll get a feel for it quickly — the Format Picture panel stays open between images, so you don't need to reopen it each time.

Step 4 — Verify it works

Try resizing the row or column — the image should stretch or shrink with it. Try sorting the data — if the image is in a data row, it should move with that row. If images don't move during sort, double-check that the Properties setting is saved and the image is positioned fully within one cell. Overlapping a border by even a pixel or two can break the anchoring behavior in some Excel versions.

One more check worth doing: hide the row the image is in. If you've set "Move and size with cells," the image should disappear when the row is hidden and reappear when you unhide it. If it just stays visible, the anchoring didn't take — open Format Picture and re-apply the setting.

Paste Special method

There's a third approach that's handy for quick inserts: copy an image from another app (a screenshot, a browser, a design tool), click a cell in Excel, and use Paste Special (Ctrl+Alt+V on Windows, Command+Control+V on Mac). Choose Picture (Enhanced Metafile) or Bitmap. The image pastes as a floating object — you'll still need to apply the "Move and size with cells" property manually afterward. It's faster than going through Insert > Pictures but the same anchoring step applies.

Method 2: Place in Cell (Excel 365 — 2023 and Later)

Microsoft added a dedicated "Place in Cell" option that skips the manual anchoring step entirely. It's only available in Microsoft 365 subscriptions (not perpetual licenses like Office 2019/2021). If you don't see it in your Insert menu, check if your subscription is current — it rolled out as part of a Microsoft 365 update starting in mid-2023.

Click your target cell, go to Insert > Pictures > Place in Cell, then choose your source (This Device, Stock Images, or Online Pictures). The image fills the cell and is anchored immediately — no right-clicking, no Format Picture panel needed.

One thing to know: the image is cropped to fit the cell's aspect ratio by default. If it doesn't look right, resize the row/column, or right-click the in-cell image to access crop and fit options. You can choose between Fill (fills the whole cell, may crop edges) and Fit (shows the whole image, may leave padding). For logos with specific proportions, Fit is usually the better pick — it preserves the original shape without cropping.

Another gotcha: you can't double-click an in-cell image to edit it. To replace it, right-click and choose Change Picture. To delete it, press Delete after selecting the cell — same as deleting cell contents.

The "Place in Cell" feature pairs well with Excel pivot tables layouts when building visual dashboards — images in cells stay in place even when the table refreshes or reorders rows.

How to Resize an Image to Fit Exactly in a Cell

Getting an image to fit perfectly in a cell takes a bit of back-and-forth. Here's the cleanest approach: first, decide which dimension to match — the cell's height or width. Resize the row height by right-clicking the row number and choosing Row Height — enter a pixel value that gives the image room. Do the same for column width. Then insert your image, hold Alt, and drag it into position. It'll snap to the cell borders. Use corner handles (not edge handles — those distort the image) to fine-tune.

For a perfectly square cell for product thumbnails: set the row height and column width to matching values. Excel uses points for row height and characters for column width, so the numbers won't be identical — but a row height of 75 and column width of 13.5 gives roughly a 100×100 pixel cell on standard displays. You can tweak from there once you see how the images look.

For high-precision work, right-click the image, choose Size and Properties, and use the Size tab to enter exact height and width in inches or centimeters. Lock the aspect ratio if you don't want distortion.

If you're building a product catalog with many images, set all your row heights and column widths before inserting any images. Select all the rows you'll use, right-click, and set them to a fixed height. Do the same for columns. Then insert and anchor each image one by one — they'll all snap to the same dimensions without manual tweaking, keeping the sheet consistent across every row.

Troubleshooting: Common Image Problems in Excel

Even after following every step, images in Excel can still behave oddly. Here are the issues people run into most — and what actually fixes them. These problems come up in all versions, though some are more common in older Excel builds.

Image won't stay inside the cell

This almost always means the "Move and size with cells" property wasn't saved, or the image is slightly overlapping the cell border. Click the image, right-click, open Format Picture, go to Size & Properties, expand Properties, and re-check the setting. Make sure the image edges are fully within the cell by holding Alt and nudging until it snaps. Even a 1-pixel overlap outside the border can break anchoring behavior in older Excel builds.

Image covers multiple cells

The image is larger than the cell. Either resize the image (drag handles while holding Shift) or expand the cell by increasing row height and column width. Right-click and choose "Size and Properties" to type exact pixel dimensions. If you're using "Place in Cell" in Excel 365, resize the row/column itself — the image scales automatically. Don't try to shrink a placed image by dragging; always resize the cell container instead.

Image doesn't move when sorting or filtering

Floating images stay put during sort and filter unless they're explicitly anchored. Open Format Picture → Properties and confirm "Move and size with cells" is selected, not "Move but don't size" or "Don't move or size." Also make sure the image is inside one specific cell, not straddling two. Excel determines which row owns the image based on where most of it overlaps — if it's right on the border between rows, the behavior becomes unpredictable. When in doubt, delete and reinsert the image after sizing the column generously.

Image doesn't print

Check three things: (1) open the Selection Pane and verify the image visibility eye icon is on; (2) confirm the image's cell is within your print area — Page Layout → Print Area → Set Print Area; (3) go to Page Setup → Sheet tab and uncheck "Draft quality" — draft mode suppresses all images to speed up printing.

Also press Ctrl+1 on the image and verify "Print object" is checked. If you're printing to a PDF driver with low-quality settings, images can be excluded — switch to the Microsoft Print to PDF driver if images are missing from PDF output.

Image looks blurry after insertion

Excel compresses images by default to keep file sizes down. Turn this off: File → Options → Advanced → scroll to Image Size and Quality → check "Do not compress images in file." This setting applies per-workbook, so you'll need to set it for each file. For logos and icons, use SVG or PNG format instead of JPG to avoid compression artifacts entirely — vector-based SVGs stay sharp at any zoom level and don't degrade under Excel's compression.

Image disappears when scrolling

The image is likely anchored to a frozen row or column. If row 1 is frozen and your image is in row 1, it'll flicker or appear to vanish as you scroll the non-frozen area. Move the image to a non-frozen area, or temporarily unfreeze panes (View → Freeze Panes → Unfreeze Panes) while positioning, then re-freeze afterward.

Image moves to wrong cell after copy-paste

Anchoring doesn't always transfer cleanly through copy-paste operations. After pasting a row that contained an anchored image, click the image in the pasted row, open Format Picture → Properties, and re-set "Move and size with cells" to re-anchor it to the new row. It's a known quirk — the property copies but sometimes points to the original row's position rather than the new one.

Image stretches when you resize the column

If you chose "Move and size with cells," resizing the column will resize the image too. That's by design. If you don't want the image to stretch when you resize, switch to "Move but don't size with cells" instead. The image will still stay in the right row, but won't change dimensions when you adjust the column width.