How to Insert a Picture Into Excel, Properly Inside the Cell

Inserting a picture into Excel is easy. Getting it to behave — to sit inside a cell, sort with the row it belongs to, and not slide across the sheet when someone filters — is the part that generates the questions.

And there is a second, entirely different task that shares the words: pulling the data out of a picture of a table, which image to Excel does with on-device OCR. Both are covered below.

Why a pasted picture floats above the grid

By default, an image in Excel is not in a cell at all. It is an object on a drawing layer that sits over the worksheet, positioned above the grid rather than within it. That single fact explains every complaint about images in Excel: they do not sort with their rows, they do not filter, they overlap when rows are hidden, and they drift when columns are resized.

Excel offers a partial fix in the image's Format Picture → Size & Properties → Properties panel: Move and size with cells. That makes the picture track the cell it overlaps when rows and columns change size — better than nothing, and still not the same as being in the cell. Sorting still leaves it behind.

Putting a picture actually in a cell

Recent versions of Excel added the thing everyone wanted: images that are cell values rather than floating objects. In Microsoft 365 and Excel for the web, use Insert → Pictures → Place in Cell.

A picture placed this way behaves like any other value. It sorts with its row, filters with it, moves when the cell moves, and can be referenced by a formula. This is what you want for a product catalogue, an asset register, a staff list or anything where each row has an image belonging to it.

If your Excel does not offer Place in Cell, it is an older version — the option does not exist before it, and no setting enables it.

The older method that still works

On an older Excel, the workable approach is to insert normally and then constrain the image.

Insert → Pictures, place the image roughly where it belongs, then drag its handles so it fits inside the cell boundaries with a small margin. Right-click → Format Picture → Size & Properties → Properties, and choose Move and size with cells. Holding Alt while dragging or resizing snaps the image to the cell grid, which is the trick that makes this quick rather than fiddly.

It is a workaround and it behaves like one under sorting. For a list that will be sorted or filtered, either upgrade or keep the images in a separate column of hyperlinks instead.

Sizing rows and columns first

Set the row height and column width before inserting anything. Excel does not resize cells to fit an image, so inserting first and adjusting afterwards means repositioning every picture.

A practical starting point for a catalogue is a row height around 80 to 100 points and a column width that gives a roughly square cell. Compress the images first, too: a spreadsheet with two hundred full-resolution phone photos in it becomes enormous and slow. Resize them to about 400 pixels before inserting, and the file stays workable.

Excel also has its own compression: select an image, then Picture Format → Compress Pictures, and untick "Apply only to this picture" to hit the whole workbook.

Getting the data out of a picture instead

The other half of this question is the reverse: you have a photograph or a screenshot of a table and you want the numbers in cells.

Excel has a built-in feature for it — Data → From Picture in Microsoft 365 and the mobile apps. It uploads the image to Microsoft's service for recognition, which is worth knowing if the table is confidential.

Image to Excel does the same job with OCR running on your device: it reconstructs the rows and columns, shows you an editable preview so you can correct anything it misread, and downloads a real .xlsx. For a screen capture specifically, screenshot to Excel is the same tool framed for that input, and screen captures recognise noticeably better than photographs because they have no perspective distortion.

Whichever you use, check the numbers before trusting the result. A misread word in a label is obvious; a 5 read as an S or a lost decimal point is invisible once it is in a spreadsheet and propagates into every total calculated from it.

Frequently asked questions

How do I insert a picture into an Excel cell?

In Microsoft 365 and Excel for the web, use Insert → Pictures → Place in Cell. The image becomes a cell value, so it sorts and filters with its row. On older versions the option does not exist and you have to constrain a floating image instead.

Why does my pasted picture float above the cells?

Because by default an image in Excel is an object on a drawing layer over the worksheet rather than a value in a cell. That is why it does not sort with its row and drifts when columns are resized.

How do I make a picture move and resize with its cell?

Right-click the image → Format Picture → Size & Properties → Properties, and choose "Move and size with cells". Holding Alt while dragging snaps the image to the cell grid, which makes fitting it much quicker.

How do I stop my spreadsheet becoming enormous with images in it?

Resize the images to around 400 pixels before inserting — full-resolution phone photos are the usual cause. Excel also has Picture Format → Compress Pictures, with an option to apply it to the whole workbook.

How do I get data out of a picture of a table into Excel?

Excel has Data → From Picture in Microsoft 365, which uploads the image to Microsoft for recognition. Image to Excel does the same on your device and shows an editable preview so you can correct misreads before downloading.

Why did the recognition get some numbers wrong?

Recognition is never perfect, and digits are where a mistake costs most because a wrong figure is invisible in a spreadsheet. A sharp, square-on capture reduces errors considerably — screen captures do much better than photographs.

Should I set the row height before or after inserting a picture?

Before. Excel does not resize cells to fit an image, so inserting first means repositioning everything afterwards. Around 80 to 100 points of row height is a practical starting point for a catalogue.

In short

Place in Cell is the answer if your Excel has it, and "Move and size with cells" is the workaround if it does not. Going the other way — a picture of a table into real cells — image to Excel keeps the image on your machine while it reads it.

Written by Mehran

Founder of QuickMerge. Practical guides built around the real behavior and limits of the tools. Connect on LinkedIn.