In Excel for Microsoft 365 on Windows, use Insert > Pictures > Place in Cell to put an image in a cell without changing the row height or column width. Excel fits the picture to the existing cell; if you need the picture to stay at its original size instead, use a floating picture and set it not to move or resize with cells.
What “in a cell” means in Excel
Excel has two different ways to display a picture in a worksheet. A traditional picture is a floating object layered over the grid. It can cover one cell or several, but it is not actually the value stored in a cell. An in-cell picture, sometimes called a picture in a cell, is associated with a specific cell and behaves more like cell content.
This distinction matters when you want to avoid changing the layout. Placing a picture in a cell does not require Excel to expand that row or column to accommodate the image. Instead, the image is fitted to the cell’s existing dimensions. A small cell therefore shows a small image. The picture cannot be both fully visible, at its original larger size, and contained within an unchanged smaller cell: one of those requirements has to give.
In-cell pictures are useful for product thumbnails, employee headshots, maps, or other small visuals that should stay aligned with records. Floating pictures are more suitable for logos, diagrams, or illustrations that need a particular on-screen size and position.
Insert a picture without changing cell dimensions
In current Microsoft 365 Excel for Windows, you can insert a picture directly as cell content. First select the destination cell. The cell can be empty or contain other content, but replacing its contents with an image means the text or value in that cell will no longer be displayed as its normal cell value.
- Select the cell where the picture should appear.
- Choose Insert > Pictures > Place in Cell.
- Choose a source, such as This Device, then select the image file and insert it.
- Check that the existing row height and column width are still suitable. The image is fitted to the cell rather than causing the cell to expand.
The exact source choices can vary with the Excel build and account, but the important command is Place in Cell, not the ordinary picture insertion option that creates a floating object. If you already inserted a picture as a floating object, right-click it and choose Place in Cell if that command is available. Excel converts it to in-cell content and fits it to the selected cell.
Images that are much wider or taller than the destination cell may appear small when fitted proportionally. If a picture looks too small, enlarging the row or column is one option, but it is not required. You can instead use a different display method or accept a crop, depending on whether showing the whole picture or filling the cell is more important.
Choose how the image fits
Keeping the grid dimensions unchanged does not guarantee that every image will look the same. A wide image in a narrow cell and a square image in a short, wide cell have different aspect ratios. Excel has to preserve the image’s proportions, crop part of it, or display it at a size that does not fill the cell.
- Fit the whole image: Preserves the full picture and its proportions, but may leave unused space inside the cell.
- Fill the cell: Uses the available area more fully, but parts of the image may be cropped.
- Keep original dimensions: Preserves the picture’s displayed size, but it may extend beyond the cell or overlap other worksheet content.
For a row of product thumbnails, fitting the whole picture is often the clearest choice because the full product remains visible. For uniformly shaped profile tiles, filling each cell can look tidier, but check that faces or important details are not cut off. A cell’s existing dimensions set the available space; changing image fit behavior does not make a small cell physically larger.
Use the IMAGE function for a linked picture
The IMAGE function is another way to show a picture in a cell. It is useful when a worksheet has image URLs in a column or when you want the picture to be generated from a cell formula. The source must be a supported HTTPS image URL; a local file path on your computer is not the same thing as a web image URL.
With an accessible HTTPS image URL in A2, this formula displays the image in the cell containing the formula and uses sizing mode 0 to fit it while preserving its aspect ratio:
=IMAGE(A2,"Product photo",0)
Here, A2 contains the URL, the second argument supplies alternative text, and 0 requests fit-to-cell sizing. This does not enlarge the row or column to match the image. Other sizing modes can fill the cell, show the image at its original size, or use specified dimensions; those choices affect the display, not the worksheet’s row and column measurements. The function is available in Microsoft 365 and Excel 2024, but may not be present in older Excel versions.
Because the formula depends on a web address, it has different practical limits from inserting a local image. A URL that requires sign-in or authentication may not load, and a broken or changed link can leave the cell without its expected image. If the workbook will be shared, test that the recipients can access the image source. For a self-contained workbook, inserting a picture from a local file as an in-cell image may be more dependable than relying on an external URL.
Keep a floating picture at a fixed size
Sometimes the real goal is not to make the picture cell content, but to stop an existing picture from changing size when rows or columns are adjusted. In that case, keep it as a floating picture and change its object properties. This lets the picture retain its displayed dimensions while the worksheet grid changes.
- Select the picture and right-click it.
- Choose Format Picture.
- In the Format Picture pane, open Size & Properties, then Properties.
- Select Don’t move or size with cells.
This setting prevents cell resizing or movement from resizing or moving the picture. The picture remains an object over the worksheet, however; it is not stored inside a cell, and it may cover cell contents. If you want it to stay associated with a location while rows or columns change size, but not scale with them, choose Move but don’t size with cells instead. The available property is a behavior setting for the floating object, not an image-cropping command.
On Excel for Mac, picture formatting controls and their pane layout can differ from Windows. Look in the picture’s formatting options for its placement or properties settings; if the exact “Don’t move or size with cells” option is not exposed in your version, use in-cell pictures or check the current Excel for Mac help for that build. Excel for the web also has a more limited set of picture-formatting controls than the desktop app.
In-cell picture or floating picture?
Use an in-cell image when the picture belongs to a particular record and should behave with that cell during sorting or filtering. For example, a product table with product names, prices, and thumbnail images is easier to maintain when each thumbnail is cell content rather than a separately positioned object. In-cell images also avoid accidental overlap with nearby text in the way floating objects can.
Choose a floating picture when precise display size and free placement matter more than cell-level behavior. A company logo placed above a report table, for example, usually should not be squeezed into a single small cell. Setting it not to move or size with cells can keep its dimensions stable while worksheet rows are adjusted.
Neither method is universally better. Consider the purpose of the image, whether it needs to sort with data, whether it must retain a particular size, and how the workbook will be used. A picture in a cell is easier to align with a record; a floating picture offers more control over layout. If the requirement is “keep the grid exactly as it is and show the whole picture,” the image may need to appear small. If the requirement is “keep the picture full-size,” it may need to remain a floating object outside the cell’s boundaries.
Common problems and practical fixes
- The row or column changed unexpectedly: Confirm you chose Place in Cell, rather than inserting a regular floating picture and manually sizing the grid around it. If grid dimensions are already changed, restore them through the row-height or column-width controls.
- The picture looks tiny: The destination cell may be small compared with the image. Increase the cell dimensions only if the layout allows it, or choose a crop/fill approach where available. A picture cannot show every detail at a large size inside a smaller fixed cell.
- The image is cut off: Check whether the image is being filled or cropped. Use a fit-whole-image option when preserving the full composition matters more than filling every pixel of the cell.
- The picture moves when sorting: A floating image may not be associated with the record you expect. In-cell pictures are generally better for images that must stay with their data. Check the result on a copy of the workbook before sorting a large or important table.
- The IMAGE formula does not load: Verify that the URL is HTTPS, points directly to an image, and can be accessed without authentication. Also check that the Excel version supports the IMAGE function.
For large worksheets, image size and file format are worth considering too. Very high-resolution photos can increase workbook size and make scrolling, saving, or sharing less convenient. Use appropriately sized source images when possible, and avoid adding multiple copies of a large image when one reusable source or a linked-image workflow meets the need.
Frequently Asked Questions
Can I put a picture in an Excel cell without changing row height?
Yes. Use Insert > Pictures > Place in Cell. Excel fits the in-cell image to the existing cell instead of expanding the row to fit the picture.
Can an image stay full-size inside a small cell?
Not if “full-size” means its original displayed dimensions and the image is larger than the cell. It must be reduced, cropped, or allowed to extend beyond the cell as a floating object.
How do I stop a picture resizing when I change column width?
For a floating picture, open Format Picture > Size & Properties > Properties and select Don’t move or size with cells. This keeps it from resizing with the grid, but does not make it cell content.
Will an in-cell image move when I sort the table?
In-cell images are associated with cells, so they are better suited than independent floating objects for images tied to sortable records. Still, confirm the behavior in a copy of your workbook if the table has complex sorting or filtering.
Can I use an image from a URL instead of inserting a file?
Yes, if your Excel version supports IMAGE and the URL is an accessible HTTPS image address. URLs that require authentication may not work, so check access before sharing the workbook.
Related
- Undo an Excel Table Without Losing Your Data
- Undo Changes in Excel After Saving: Your Recovery Options
- How to Turn On AutoFit in Excel for Rows and Columns
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Unhide Rows in Excel That Won’t UnhideIf Excel’s Unhide Rows command does nothing, first select the rows on both sides of the missing section…
- Excel Data Validation Lists Based on CriteriaTo make an Excel drop-down list change according to a criterion, put a FILTER formula in a helper…
- Can You Insert a Horizontal Line in Word?Yes. In Microsoft Word for Microsoft 365 on Windows, you can insert a horizontal line from Home >…
- Outlook Block Sender List Limit: What You Need to KnowOutlook’s blocked-sender list generally supports up to 1,024 entries, with an email address or domain counting as an…
- How to Make a Bifold Brochure in Word, Step by StepTo make a bifold brochure in Microsoft Word, create a two-page landscape document, divide each page into two…
- Inserting Images in Excel: Steps, Sizing, and TipsTo insert an image in Excel for Microsoft 365 on Windows, select the worksheet, choose Insert > Pictures…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.