To insert an image in Excel for Microsoft 365 on Windows, select the cell near where you want it, then choose Insert > Pictures > This Device, select the image file, and choose Insert. Excel adds the picture as an object over the worksheet; you can then resize and position it. If your version offers Place in Cell, you can use that option to put the picture inside a cell instead.
What You’ll Need
- An Excel workbook you can edit in Microsoft Excel for Microsoft 365.
- An image file you can access, such as a PNG, JPG, or GIF. Save an online image to your device first if Excel cannot access it directly.
- A rough idea of where the picture should go and how large it should appear. If it needs to line up with rows or columns, adjust those before fine-tuning the picture.
The steps below focus on Excel for Windows. Excel on Mac and Excel for the web have similar insertion options, but button names and available picture features can vary. Save the workbook before making extensive layout changes, especially if it is shared or contains important data.
Step-by-Step
- Open the worksheet and choose a location. Open the workbook, then click the cell nearest the spot where you want the image. This selection gives you a useful starting point, but a regular inserted picture will not automatically become part of that cell. It floats above the grid and can cover cells. If the picture is a logo or chart illustration, leave room around it; if it belongs to a particular record, consider placing it beside that record and using a consistent column for all images.
- Open the picture insertion command. On the ribbon, select Insert, then open Pictures and choose This Device. Depending on your Excel update, the Pictures button may be a dropdown or may show picture sources directly. In the file picker, browse to the folder containing the image. For an image stored in a cloud-synced folder, wait until the file is available locally if it has not been downloaded yet.
- Select the image file. Click the file you want to use and select Insert in the file picker. Excel adds it to the active worksheet, usually near the center of the visible area rather than exactly inside the selected cell. You can also select more than one image in the file picker in many versions, but inserting them individually is easier when you need to place and size each one precisely. Avoid choosing a file type that Excel cannot display; PNG and JPG are suitable for most ordinary pictures.
- Move the picture into place. Click the picture once so its border and sizing handles appear. Point to the picture itself, away from the small handles, and drag it to the desired location. Use the worksheet grid as a guide: align the picture’s left edge with a column boundary or its top edge with a row boundary if that helps the sheet look orderly. If you accidentally select a cell instead, click the picture again and make sure the selection handles are visible before dragging.
- Resize without distorting it. Drag a corner handle inward or outward to change the picture’s size while keeping its proportions. Avoid dragging a handle at the middle of an edge if you do not intend to stretch or squash the image. For a more precise size, select the image and use the height and width controls in the Picture Format tab’s Size group. If those controls are not visible, confirm that the picture—not a cell—is selected and widen the Excel window or look for the collapsed ribbon controls.
- Choose whether the picture should sit in a cell. A standard inserted picture is a floating object that lies above the grid. In supported Microsoft 365 versions, select the picture and look for Picture Format > Place in Cell, or choose Insert > Pictures > Place in Cell when inserting. The exact option can depend on your update. A picture placed in a cell behaves more like cell content and can be easier to manage in a table. If you do not see the command, use a floating picture and set its cell behavior in the next step instead.
- Set how a floating picture responds to cells. Right-click the picture and choose Format Picture. In the formatting pane, open Size & Properties, expand Properties, and choose the behavior that fits your layout. Move and size with cells makes the picture move and change size with its underlying rows and columns. Move but don’t size with cells keeps its size while moving with the cells. Don’t move or size with cells leaves it independent of grid changes. These settings apply to floating pictures, not pictures placed in cells.
- Check the result and save. Click a blank cell to see how the picture looks without its selection border. Scroll through the sheet and check that the image does not obscure labels, values, or buttons. If it needs another adjustment, select it again and use the arrow keys for small movements after clicking the object, or drag it carefully. Save the workbook with Ctrl+S on Windows. If the file is shared, verify the layout after saving or reopening it.
On Mac: Select Insert and use the picture command, commonly labeled Pictures or Picture from File, then choose the file. The Mac ribbon and formatting pane may use slightly different labels. In Excel for the web: use the Insert tab’s picture option to upload or select an available image. Some desktop-only sizing and placement controls may be missing or limited in the browser.
Common Mistakes
- Assuming the image is inside the selected cell. Selecting a cell before inserting a picture does not normally anchor the picture as cell content. It is a separate object layered over the worksheet unless you use a supported Place in Cell option.
- Dragging an edge handle and changing the shape. A picture can become too wide or too tall if you resize from a middle handle. Use a corner handle, or enter dimensions in the Size controls, to preserve its appearance.
- Putting a picture over important information. Pictures can hide values and make a worksheet hard to read. Leave clear space, move the image beside the relevant data, or adjust row heights and column widths deliberately.
- Expecting a floating picture to sort with its row. Unless it is placed in a cell or its object properties are set appropriately, a picture may not follow a record the way you expect when sorting or filtering. Test the behavior on a copy of the sheet before sorting a large table.
- Using an unnecessarily large image. A high-resolution photo can increase workbook size and slow sharing or opening. Resize or compress a copy of the image before inserting it if the original is much larger than it needs to be on the sheet.
Tips
- Plan the grid first. Set the relevant column width and row height before positioning a picture. This reduces repeated adjustments, particularly when adding a series of product photos or staff headshots.
- Use consistent dimensions. For a list of images, select each one and use matching height and width values in the Picture Format Size controls. Keep the source images’ proportions in mind so that matching both dimensions does not stretch them.
- Keep images identifiable. Use meaningful file names before insertion, and add alternative text where it will help someone understand the picture. Right-click the picture and look for View Alt Text or the alternative-text command to add a short, useful description.
- Consider cell-based pictures for structured lists. Where Place in Cell is available, it can make image rows easier to sort and manage. Make sure each picture fits the cell and check the result after changing row height or column width.
- Use a copy when experimenting. If you are changing many image sizes, moving objects, or preparing a table for sorting, duplicate the worksheet or save a copy of the workbook first. That gives you a straightforward way to return to the original layout.
Troubleshooting
The Pictures command or This Device option is missing: Check that you are on the Insert tab and that the ribbon is expanded. In a narrow window, some commands may be grouped under a dropdown or overflow menu. Excel for the web and managed work accounts can have different available sources; try the desktop app or ask your administrator if the command is restricted.
The image does not appear after you insert it: Look around the visible worksheet because Excel may have placed it away from the selected cell. Use the zoom controls or scroll to find it. If the file picker accepted the file but nothing appears, check that the format is supported and that the file is not damaged. Try opening the image outside Excel, then insert a fresh copy saved as PNG or JPG.
The picture is too large, blurry, or distorted: Select it and resize from a corner handle. If it looks blurry even at a small size, the source image may have low resolution; use a clearer original rather than enlarging it. If its proportions look wrong, undo the last resize with Ctrl+Z on Windows, then resize from a corner or enter the intended dimensions in the Size group.
The picture moves when rows or columns change: That is controlled by its object properties. Right-click the floating picture, open Format Picture, and check Size & Properties > Properties. Choose the move-and-size behavior that matches your layout. If it is a picture placed in a cell, adjust the cell dimensions instead of trying to drag it independently.
The image covers data or appears behind another object: Move it to an open area or change its stacking order using the picture formatting commands, if available. You can also make more room by adjusting the worksheet’s row heights or column widths. Avoid hiding data under pictures; a reader may not realize that values are covered.
Frequently Asked Questions
Can I insert an image directly into an Excel cell?
In supported Microsoft 365 versions, use Place in Cell when inserting or select an existing picture and use the placement command if it appears. Otherwise, Excel inserts a floating picture that sits over cells; you can set how it responds to cell changes through its properties.
Which image file types can I use?
Common formats such as PNG, JPG/JPEG, and GIF work for typical worksheet pictures. Support can depend on the Excel version and the file itself. If Excel rejects a format, convert a copy to PNG or JPG and try again.
How do I make a picture fit inside a cell?
First set the row height and column width. For a picture placed in a cell, adjust the cell dimensions and check that the image displays as intended. For a floating picture, resize it with a corner handle and position it over the cell; it will not become cell content merely because it fits inside the grid.
Will the picture move when I sort or filter a table?
A floating picture may not stay associated with the correct record. Use Place in Cell if your Excel version offers it, or set the floating picture’s properties and test sorting on a duplicate worksheet. Confirm that each image still matches its row before relying on the result.
How do I remove an image without deleting worksheet data?
Click the picture’s border or handle so the object itself is selected, then press Delete. If a cell is selected instead, pressing Delete may clear cell contents rather than remove the picture. Click the image again until its selection handles appear before deleting.
Can I insert an image in Excel for the web or on a Mac?
Yes. Excel for the web and Excel for Mac provide picture-insertion commands, though the labels and available options can differ from Windows. The web version may have fewer formatting controls, and Place in Cell may not be available in every version or account.
Related
- How to Freeze the Top Row in Excel While Scrolling
- Freeze Rows in Excel With Keyboard Shortcuts: Step-by-Step
- Freeze Panes in Excel: Keep Rows and Columns Visible
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 Schedule an Email in Outlook for a Later TimeTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send, and…
- How to Link a Drop-Down List in ExcelTo link a drop-down list in Excel to a range, select the destination cell, choose Data > Data…
- Excel: Sum a Filtered Column with SUBTOTALTo sum only the visible values in a filtered Excel column, use =SUBTOTAL(9,B2:B7), replacing B2:B7 with your data…
- Merge Columns in Google Sheets: Methods, Tips, and FixesTo join the text or values in two Google Sheets columns, enter a formula such as =A2&" "&B2…
- Word: Make One Page Landscape Without Changing OthersTo make just one page landscape in Microsoft Word for Microsoft 365 on Windows, select the content on…
- Excel Insert Row Below a Selected Row: Quick StepsTo insert a worksheet row below the row you selected in Excel, select the row header immediately underneath…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.