How to Paste an Image Into an Excel Cell or Google Sheets
You copy a product photo, click a cell in your spreadsheet, and press Ctrl+V. The picture appears, but it is floating on top of the grid rather than sitting in the cell you clicked. Sort the column and the picture stays where it was while the rows move underneath it. Filter the sheet and it hangs over the wrong row. This is the default in both Excel and Google Sheets, and it is the reason "paste image into cell" is such a common search.
Both apps can now put a picture inside a cell, where it behaves like any other value: it moves when you sort, hides when you filter, and resizes with the row. The option just is not what Ctrl+V does. This guide covers the exact menu paths in current Excel and Google Sheets, how to convert a picture you already pasted, what to do in older versions of Excel that lack the feature, and how to handle a screenshot that is only on your clipboard when the menu insists on a file.
Floating Pictures vs In-Cell Pictures
It helps to know which of the two you have, because the fix depends on it.
- A floating picture sits on a layer above the grid. You can drag it anywhere, resize it freely, and it can cover several cells. Selecting it shows sizing handles and, in Excel, a Picture Format tab on the ribbon. Sorting, filtering, and formulas cannot see it, because it is not in any cell.
- An in-cell picture is the cell's value, the same way a number or a piece of text would be. It fits inside the cell's borders, it has no sizing handles, and clicking it selects the cell. It travels with its row when you sort and disappears when a filter hides that row. In Excel, a lookup formula can even return it.
If you are building a product catalog, an inventory list, a staff directory, or anything else where each row needs its own picture, you want in-cell pictures. Floating pictures are still the right choice for a logo in a report header or an annotated screenshot laid over a chart.
Paste an Image Into an Excel Cell (Microsoft 365 and Excel 2024)
Current versions of Excel have a dedicated in-cell paste. According to Microsoft's own documentation, the Place in Cell feature is available in Microsoft 365 and Excel 2024. With an image on your clipboard:
- Click the cell where the picture should go.
- On the Home tab, click the arrow under Paste and choose Paste Picture in Cell. The same option is in the right-click menu under the paste options.
- The image appears inside the cell, scaled to fit while keeping its proportions. Make the row taller and the column wider if you want it bigger.
If the image is a file on your computer rather than something on your clipboard, go to Insert, then Pictures, then Place in Cell, and pick This Device. The same menu also offers stock images and online pictures. Excel accepts JPG, PNG, BMP, ICO, WebP, TIFF, and non-animated GIF files for in-cell pictures.
Converting a Picture You Already Pasted
If you pressed Ctrl+V out of habit and now have a floating picture, you do not need to delete it and start over. Right-click the picture and choose Place in Cell. Excel moves it into the cell under the picture's top-left corner. To go the other way, right-click a cell that contains a picture and choose Place over Cells, which turns it back into a floating picture you can drag and resize.
Pictures From a Web Address: the IMAGE Function
If your images already live online, for example product photos on your store's CDN, you do not need to paste anything. Microsoft 365 includes an IMAGE function that loads a picture into a cell from a URL:
=IMAGE("https://example.com/photo.jpg", "Blue mug, front view")
The first argument is the address, which must use https. The second is optional alt text for screen readers. A third, optional sizing argument controls the fit: 0 fits the picture inside the cell and keeps its proportions, 1 stretches it to fill the cell, 2 shows it at original size, and 3 lets you give a custom height and width. Because it is a formula, you can fill it down a column and point each row at a different URL stored in another cell.
Older Excel Versions: Make a Floating Picture Behave
Excel 2021, 2019, and earlier do not have Place in Cell or the IMAGE function. Pictures in those versions are always floating. You can still get most of the behavior you want with one setting:
- Paste the picture, then resize it so it fits within the cell's borders. Hold Alt while dragging to snap its edges to the gridlines.
- Right-click the picture and choose Size and Properties (on some versions, Format Picture, then the Size and Properties icon).
- Under Properties, choose Move and size with cells.
Now the picture moves when rows move, shrinks when you shrink the row, and is hidden along with its row by a filter. Sorting also carries it along, as long as the picture sits fully inside a single cell. A picture that overlaps a cell border can end up attached to the wrong row, which is the most common reason this approach seems to fail.
Paste an Image Into a Google Sheets Cell
Google Sheets works the same way in principle: Ctrl+V gives you a floating picture, and there is a separate command to put one inside a cell.
- Click the cell where the picture should go.
- Open Insert, then Image, then Insert image in cell.
- Choose where the picture comes from: an upload from your computer, a web address, your camera, Google Drive, Google Photos, or a Google Images search.
To convert a picture you already pasted with Ctrl+V, click it, open the three-dot menu that appears at its top-right corner, and choose Put image in selected cell. Sheets moves it into whichever cell is currently selected, so click the right cell first, then the picture.
One rule catches people out: a Google Sheets cell holds either a picture or text, not both. If you want a caption or a product name, put it in the next column.
The IMAGE Function in Google Sheets
Sheets has had an IMAGE function for years, and it works much like Excel's. =IMAGE("https://example.com/photo.jpg") loads the picture into the cell. An optional second argument sets the mode: 1 fits the picture inside the cell and keeps its proportions (the default), 2 stretches it to fill the cell, 3 shows it at its original size, and 4 lets you give a custom height and width in pixels as the third and fourth arguments. The URL has to be publicly reachable. A link to a private Google Drive file or a page that requires you to be logged in will show an empty cell.
When the Image Is Only on Your Clipboard
Excel's Paste Picture in Cell reads straight from the clipboard, so a screenshot you just copied works directly in current versions. Google Sheets is the one that tends to cause trouble. The Insert image in cell dialog is built around uploading a file, and whether it accepts a pasted image depends on your browser and how the image got onto the clipboard. The same is true of Excel for the web in some browsers, and of older desktop versions where you want to use the Insert menu instead of pasting.
The fix is to turn the clipboard image into a file first:
- Open PasteDownloadApp in another tab.
- Press Ctrl+V (Cmd+V on a Mac). The image appears in the preview with its dimensions and size.
- Choose PNG for screenshots with text, or JPEG for photos, and download. The file lands in your Downloads folder with a timestamped name.
- Back in your spreadsheet, use the upload or This Device option and pick the file you just saved.
The conversion happens inside your browser, so a screenshot of internal data or a customer record is never uploaded anywhere except the spreadsheet you chose. If you are not sure why a copied image is not a file yet, where screenshots and copied images actually go explains the difference.
Getting the Size Right
An in-cell picture is only as large as its cell. A default Excel row is about 20 pixels tall, so a pasted photo looks like a thumbnail until you change the row height. A few habits make image-heavy sheets much easier to work with:
- Set the row height before you insert. Select all the rows that will hold pictures and set one height for all of them, for example 80 or 100 pixels. Every picture then scales to the same size.
- Crop before you paste. The cell shows the whole image, scaled down. If only part of a screenshot matters, crop it first, so the important part is not a few pixels wide inside the cell.
- Do not paste huge originals. A 4000-pixel phone photo in each of 500 rows makes a workbook slow to open, scroll, and share. The cell will never show that detail anyway. Pictures of roughly 400 to 800 pixels on the long side are plenty for a catalog.
- Pick the format on purpose. JPEG or WebP keeps photos small. PNG keeps screenshots and logos sharp. The PNG vs JPG vs WebP comparison has real file sizes for both kinds of image.
Troubleshooting
I do not see Paste Picture in Cell or Place in Cell
Your version of Excel does not have the feature. It is limited to Microsoft 365 and Excel 2024. Check File, then Account, to see which version you have, and install pending updates if you have a Microsoft 365 subscription. On older versions, use the Move and size with cells approach described above.
The picture pasted, but it is tiny
That is the cell size, not the picture. Increase the row height and column width. In-cell pictures always scale to fit their cell.
Pasting does nothing at all
Check that the clipboard actually holds image data. Copying an image's address, or copying a file in File Explorer or Finder, puts text or a file reference on the clipboard, not the picture itself. Right-click the image and use "Copy image", or take the screenshot again with a copy-to-clipboard shortcut. Why clipboard access fails covers the other common causes.
The IMAGE formula shows an error or an empty cell
The URL has to point directly at an image file and be publicly accessible over https. Links to web pages that contain an image, private cloud files, or addresses that require a login will not load. Open the URL in a private browser window. If you see just the image, the formula should work.
Frequently Asked Questions
Can I sort and filter rows that contain pictures?
Yes, if the pictures are in-cell pictures. They behave like any other cell value and move with their rows. Floating pictures only follow along in Excel if they are set to Move and size with cells and sit fully inside one cell.
Can I put text and a picture in the same cell?
Not in Google Sheets, where a cell holds one or the other. In Excel, an in-cell picture is the cell's value, so the practical answer is also no. Use a neighboring cell for the label.
Does this work in Excel on a Mac?
Yes. Microsoft 365 for Mac includes Place in Cell and the IMAGE function. The paste command is under the same Paste menu, and Cmd+V still creates a floating picture by default.
Will the pictures still be there if I download the Google Sheet as an Excel file?
Pictures inserted with Insert image in cell are generally carried over when you download a Sheet as .xlsx, but results depend on which version of Excel opens the file. Check the downloaded copy before you delete the original.
Related Guides
5 Faster Ways to Save Clipboard Images Without Software Compare browser-based and built-in methods for saving copied images on desktop and mobile.
Where Do Screenshots Go on Windows, Android, and iPhone? Screenshots and copied images do not behave like normal files until you save them. Here is where they go on Windows, Android, and iPhone.
PNG vs JPG vs WebP: Real File Sizes Compared PNG vs JPG vs WebP for quality, transparency, and file size, backed by real measured results, not general claims.
Why "Access Clipboard" Fails, and How to Fix It Clipboard read permission errors explained: browser support, HTTPS requirements, and permission prompts.