To insert an image as a movable object in Excel for Microsoft 365 on Windows, select the worksheet, choose Insert > Pictures > This Device, select the image, and choose Insert. Excel places the picture over the cells as a separate object that you can move, resize, and format. If by “object” you mean an embedded file with an icon or an OLE-style object, use Insert > Object instead; that is a different feature and usually is not the best way to show a picture in a worksheet.
What You’ll Need
- A workbook you can edit in Microsoft Excel for Microsoft 365 on Windows.
- An image file saved somewhere you can browse to, such as a PNG, JPEG, or GIF. A clear, appropriately sized image is easier to position and keeps the workbook manageable.
- Optional: the approximate cell area where you want the picture to sit. If it should line up with data, adjust the column widths and row heights first.
Step-by-Step
- Open the worksheet and choose a location. Open the workbook, then select the worksheet where the image belongs. Click a cell near the picture’s intended upper-left corner. The cell selection helps you orient the insertion, but a picture placed over cells is not stored inside that cell: it floats above the grid and can overlap several cells. If the picture needs to sit neatly alongside a table, decide which rows and columns it should cover before inserting it.
- Insert the picture over the cells. On the ribbon, select Insert > Pictures > This Device. Browse to the image, select it, and click Insert. In Microsoft 365 builds that show placement choices, choose Place over Cells before selecting the file. This creates a selectable picture object on the worksheet. Do not choose Place in Cell if you want a freely movable, overlapping picture; that option puts the image inside a cell instead.
- Confirm that it is a picture object. Click the image once. You should see sizing handles around it, and Excel should show a contextual Picture Format tab on the ribbon. Drag the picture slightly to confirm that it moves independently of the cell contents. If the image appears within a cell and follows the cell’s boundaries, it was inserted using the in-cell option; undo with Ctrl+Z and insert it again as a picture over cells.
- Move it into position. Point to the middle of the image, away from the round sizing handles, until the pointer indicates that you can move it. Drag the picture to the intended location. For a more controlled placement, select the object and use the arrow keys to nudge it; hold Ctrl while pressing an arrow key on Windows for smaller movements in many Excel builds. Zooming in can make alignment easier. Avoid dragging a handle when you mean to move the whole picture.
- Resize without distorting it. Select the image and drag a corner handle inward or outward. Corner handles preserve the picture’s proportions in current Excel versions; side handles can stretch or squash it. For an exact size, open the Picture Format tab and enter values in the Height and Width boxes in the Size group. If changing one measurement alters the other, keep the aspect ratio locked; the control’s location can vary by ribbon layout. Check that text or important details have not been cropped.
- Choose how it behaves when cells change. If the picture should travel with its related rows or columns, right-click the picture and choose Format Picture. In the pane, open Size & Properties, expand Properties, and select the behavior you want: Move and size with cells, Move but don’t size with cells, or Don’t move or size with cells. The first option makes the picture follow cell movement and resize with cells. The second follows moved cells but retains its dimensions. The third keeps its worksheet position and size when cells are adjusted. Choose based on how the sheet will be edited, not just how it looks now.
- Set its stacking order and alignment. When pictures overlap cells, charts, or other shapes, select the image and use the Picture Format tab’s Bring Forward or Send Backward controls to change which object appears on top. For alignment, use the ribbon’s Align commands where available, or move the object while zoomed in. If you are selecting a picture hidden behind another object, open Home > Find & Select > Selection Pane, then select its entry in the list.
- Add descriptive text if needed. For accessibility, right-click the image and choose View Alt Text or the available alt-text command. Enter a short description of the information the image conveys. If it is purely decorative and adds no information, mark it as decorative when that option is available. Alt text does not change the image’s position or appearance; it helps people using screen readers understand its purpose.
- Save and check the result. Save the workbook, then scroll through the surrounding cells and confirm the picture remains in the right place. If other people will open the file, close and reopen it or check a copy on their version of Excel. Consider whether the workbook should be protected from accidental changes: worksheet protection can restrict editing of objects, so set protection options carefully if users need to move or resize the picture.
Common Mistakes
Choosing Place in Cell when you want a floating object. Excel’s newer image-placement options can make this easy to miss. An in-cell picture is associated with one cell and behaves differently from a picture sitting above the grid. For an object you can position across multiple cells, choose Place over Cells, or use the standard Insert > Pictures > This Device route when that is the available command.
Assuming the picture belongs to the cell beneath it. A picture over cells is a separate worksheet object, even when its corner appears to line up with a cell corner. Sorting, filtering, inserting rows, or changing column widths can affect its location depending on its properties. Set the right cell behavior rather than relying on visual alignment alone.
Dragging a handle and accidentally distorting the image. Use a corner handle for ordinary resizing and avoid pulling a side handle unless you deliberately want to change the proportions. For logos, product photos, and screenshots with text, distortion can make the image look unprofessional or harder to read.
Inserting a huge original file. A high-resolution photo can make a workbook slow to save, share, or open even when displayed at a small size. Resize or compress a copy of the image before inserting it if the original dimensions are unnecessary. Keep a separate original if you may need it later.
Using Insert > Object for a picture you want to see on the sheet. The Object command is for embedding or linking supported file types through an object handler; it can show an icon or an object representation rather than a convenient worksheet picture. Use Insert > Pictures for an image that should be visible, movable, and resizable on the grid.
Tips
- Make cell behavior intentional. For a logo next to a report heading that should stay with the heading when rows move, try Move but don’t size with cells. For a small picture that should scale with a table cell, choose Move and size with cells. For a decorative image fixed to a dashboard layout, Don’t move or size with cells may be preferable.
- Use the Selection Pane for crowded sheets. Open Home > Find & Select > Selection Pane to see and select objects by name. Rename important objects there if the pane allows it in your version. This is more reliable than clicking repeatedly when a chart or shape covers the image.
- Keep the image readable at normal zoom. A picture that looks clear at 200% may be too small at the worksheet’s usual zoom. Check it at the scale colleagues will use, especially if it contains labels, a signature, or fine print.
- Consider workbook size and sharing. Inserting a picture generally stores its image data in the workbook, increasing file size. Use a sensible resolution and a supported image format. If you link an external file through an object workflow instead, recipients may not have access to the same file path.
- Be cautious with protection. If the sheet is protected, users may be unable to select or adjust a picture. Set protection to allow object editing if that is required, and test the permissions before sharing the workbook.
Troubleshooting
The picture is inserted in a cell, not floating above the grid. Undo the insertion, then choose Place over Cells if Excel presents the option. If the menu only offers a standard picture command, use Insert > Pictures > This Device. Select the resulting picture and check that sizing handles appear around the whole image.
The picture will not move or resize. Confirm that you selected the picture, not a cell, and that the worksheet is not protected in a way that prevents object editing. Try selecting it through the Selection Pane. If the file is open in Excel for the web, some object-editing controls may be limited; open it in the desktop app for fuller formatting and object-property options.
The picture shifts after rows or columns change. Right-click it, open Format Picture > Size & Properties > Properties, and select the appropriate movement and sizing behavior. Then reposition it if needed. These settings govern how the object reacts to cell changes; they do not necessarily lock it permanently to a specific cell.
The image looks stretched, blurry, or clipped. Resize from a corner rather than a side. If the image is blurry, insert a higher-resolution source instead of enlarging a small thumbnail. If part of the image is hidden, check whether another object is in front of it, whether cropping has been applied, or whether the image extends beyond the visible worksheet area.
You cannot find the picture after inserting it. Use Home > Find & Select > Selection Pane to locate it, or zoom out and inspect the area around the selected cell. A picture can be placed far from the active cell, especially after a prior insertion or worksheet edit. Selecting its name in the pane should make its handles visible.
The Object command does not show the image as expected. Return to Insert > Pictures for an ordinary visible picture. If you genuinely need to embed a file as an object, select Insert > Object > Create from File, browse to the file, and choose whether to display it as an icon if that option is available. Support and appearance depend on the file type and installed handlers; this is not the same as placing a picture on the worksheet.
Frequently Asked Questions
Is an image inserted with Pictures actually an Excel object?
Yes. A picture placed over cells is a worksheet object that Excel lets you select, move, resize, layer, and format. It is not the same as an image value placed inside a cell, nor is it an embedded OLE file object.
How do I insert a picture inside a cell instead?
In Microsoft 365 versions with the feature, choose Insert > Pictures > Place in Cell, then select the source. You can also use the picture’s context menu to place an existing image in a cell where supported. The wording and availability can vary by update channel; choose Place over Cells when you need a floating object.
Can I insert a picture as an embedded file object?
Use Insert > Object > Create from File on Windows and browse to the file. If available, Display as icon shows an icon rather than a large visible picture. Whether a particular image file is handled as an embedded object depends on Windows and the file type. For a picture people should see directly on the worksheet, use the Pictures command.
Does the picture move when I sort or filter rows?
It depends on its object properties and the worksheet operation. Set Move and size with cells or Move but don’t size with cells when the picture should follow cell changes, then test the specific sort or filter behavior on a copy. A floating image is not automatically part of the cell’s value or record.
Can I do this in Excel for Mac or Excel for the web?
Yes, both support inserting ordinary pictures, although ribbon labels and available object options differ. On Mac, use the Insert tab and choose the picture-from-file command, then position and format the picture; the Windows Insert > Object workflow and some object properties may not be available in the same form. Excel for the web supports picture insertion and basic adjustments, while the desktop app is the better choice for advanced object properties or embedded-file workflows.
Will the image appear when I send the workbook to someone?
An image inserted as a worksheet picture is normally saved within the workbook, so it travels with the file. Check the saved workbook before sharing, particularly if it contains many large images. A file linked from an external location may not be available to the recipient if they cannot access that location.
Related
- How to Insert Figures Into a Table of Contents in Word
- Insert an Editable Checkbox in Word: A Step-by-Step Guide
- Insert an Electronic Signature in Word
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 Group Dates by Year in Excel with a PivotTableTo group dates into years in Excel, place the date field in a PivotTable, right-click any date in…
- Highlight Duplicates in Excel Lists: Step-by-StepTo highlight repeated values in an Excel list, select the cells you want to check, then choose Home…
- How to Make 2 Columns in Word for Part of a PageTo make only part of a page two columns in Word, select the text, then choose Layout >…
- Adding a Citation in Word: Steps, Styles, and TipsTo add a citation in Microsoft Word for Microsoft 365 on Windows, open the References tab, choose a…
- Lock Cells Together in Google Sheets: Step-by-StepTo lock cells together in Google Sheets, select the range, choose Data > Protect sheets and ranges, and…
- How to Make a Number Superscript in ExcelTo make part of an entry superscript in Excel for Microsoft 365 on Windows, edit a text cell,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.