How to Insert an Image in Excel Without Moving Cells

How-to basics · Updated November 20, 2026

To keep an image from moving or changing size when you adjust worksheet cells, insert it as a floating picture, then set its property to Don’t move or size with cells. In Excel for Microsoft 365 on Windows, right-click the picture, choose Format Picture, open Size & Properties, expand Properties, and select that option. The picture will stay in place relative to the worksheet rather than following cell changes.

What You’ll Need

  • Excel for Microsoft 365 on Windows. The instructions below use the desktop app, where the picture placement options are available.
  • An image file saved somewhere you can access, such as a PNG or JPEG. You can also use another supported image format.
  • A worksheet and a rough idea of where the picture should sit. Leave room around the intended position if you do not want it to cover cell content.

If you are using Excel for the web, you can insert pictures, but some picture-formatting controls can differ from the desktop version. If you cannot find the placement property in the browser, choose Open in Desktop App and set it there. On a Mac, the names and arrangement of pane controls can differ slightly; the key setting is still the picture property that prevents it moving or resizing with cells.

Step-by-Step

  1. Open the worksheet and choose the picture location. Select the sheet where you want the image. Consider the cells it will cover and whether it belongs near a heading, chart, or group of data. A floating image sits above the grid, so it can obscure values or labels underneath it. If necessary, widen the columns or make space before inserting the picture.
  2. Insert the image as a floating picture. On the Windows ribbon, choose Insert > Pictures > This Device. Browse to the image, select it, and click Insert. Depending on your Excel build, the button may be labelled Pictures and show options such as This Device. Avoid choosing an option labelled Place in Cell if your goal is for the image to remain independent of cell movement; a picture placed in a cell is designed to behave as cell content.
  3. Position and size the image. Drag the picture to the desired spot. Use the corner handles to resize it while keeping its proportions; dragging a side handle can stretch it. For a precise size, select the picture and use the Picture Format tab’s Size controls. If the image is too large, reduce it before setting its placement property so it does not hide important worksheet information.
  4. Open the picture’s formatting pane. Right-click the picture and choose Format Picture. A formatting pane should appear at the right of the Excel window. If a different context menu appears, check that the picture itself is selected rather than a cell, chart, or shape. You can also use Ctrl+1 on Windows with the picture selected to open its formatting options.
  5. Find the placement properties. In the Format Picture pane, select Size & Properties, then expand the Properties section. Depending on the pane layout, you may need to click the small disclosure arrow next to the section name. Look for three choices: Move and size with cells, Move but don’t size with cells, and Don’t move or size with cells.
  6. Choose “Don’t move or size with cells.” Select the third option. This is the setting that keeps the picture from shifting or changing dimensions when you adjust row heights or column widths. It does not lock the picture against being dragged or resized manually; it controls how the image responds to changes in the worksheet grid.
  7. Close the pane and check the result. Click outside the pane, then change a nearby column width or row height slightly. The picture should remain at its existing worksheet position and size. Undo the test if you do not want to keep the cell adjustment. You can also move the image slightly by dragging it if you want to fine-tune its placement.
  8. Save the workbook. Save with Ctrl+S on Windows or Command+S on Mac. Close and reopen the file if you want to confirm the picture and its property are retained. If you plan to share the workbook, test it in the version of Excel your recipients will use.

On Mac, select the picture and open its formatting controls, often through Format Picture in the context menu or the Picture Format ribbon. Look in the picture-formatting pane for Size & Properties and the same cell-placement choices. If the pane’s tabs or icons look different, inspect the section names rather than relying on a particular icon. Excel for the web may not expose all of these controls; use the desktop app when the property is missing.

One important limitation: “Don’t move or size with cells” means the picture is positioned independently of cell dimensions. It does not pin the picture to a fixed screen coordinate. Scrolling moves the worksheet beneath the window, and the image will scroll out of view with the part of the sheet where it sits. It also does not guarantee that a picture will stay associated with a particular record when you sort data. If the image must travel with a row, use a cell-based picture or a move-with-cells option instead.

Common Mistakes

  • Choosing “Move but don’t size with cells.” This prevents resizing with cells, but it still allows the picture to move when rows or columns change. Choose Don’t move or size with cells when you want both behaviours turned off.
  • Inserting the picture in a cell by mistake. Excel’s cell-based picture feature is useful when images should belong to individual cells, but that is different from a floating image that stays independent of the grid. Use the regular device picture insertion option for the floating-picture method here.
  • Expecting the setting to stop every kind of movement. The option governs changes to cells; it does not prevent someone from dragging the picture, editing the sheet, or moving the worksheet’s view by scrolling. Protect the sheet or control editing access if preventing manual changes matters.
  • Placing the picture over important data. A floating picture can hide text and values without deleting them. Check the cells underneath it, and move or resize the image before sharing or printing the workbook.
  • Assuming the image will follow a sorted row. An independently positioned picture is not reliably tied to the contents of a record. If it must stay with a particular item as rows are sorted, use an image-in-cell approach and check the behaviour in your Excel version.
  • Forgetting that pictures can affect printing. A picture may print if it lies inside the print area, even if it looks separate from the data on screen. Use File > Print to preview the page layout before distributing a printed copy or PDF.

Tips

  • Use the selection pane for crowded sheets. Choose Home > Find & Select > Selection Pane to locate and select objects when several pictures, charts, or shapes overlap. Selecting an object there can be easier than clicking a small edge on the grid.
  • Keep a consistent picture size. Select the picture and use the Picture Format tab’s height and width controls when you need a specific size. If the picture’s proportions change unexpectedly, undo the change and resize from a corner handle, or check the pane’s size options.
  • Use cell alignment as a visual guide, not as a lock. You can place the image near a cell corner or align it alongside a table, then set the independent placement property. The grid helps with visual positioning even though the image will not follow later row or column adjustments.
  • Check the workbook at the size others will view it. Zooming changes how large objects look on screen, but does not change their actual size. Check at a normal zoom and use Print Preview when the worksheet is intended for paper or PDF.
  • Keep the original image file. The workbook stores or references the inserted picture according to how it was added and the Excel environment. Keeping a copy of the source makes it easier to replace the image or create a smaller version if the workbook becomes large.
  • Protect the sheet only when needed. Worksheet protection can restrict changes to objects, but it may also limit other editing. Set and test protection carefully, and do not treat the cell-placement property as a substitute for access control.

Troubleshooting

The picture still shifts when I change a column width. Reopen Format Picture > Size & Properties > Properties and confirm that Don’t move or size with cells is selected. The middle choice is easy to confuse with the last one. Also confirm that the selected object is the picture you meant to change, especially if the sheet contains several images.

I can’t find “Format Picture” or “Properties.” Click the picture’s border once to select it, then right-click that border. If the cell is selected instead, the context menu will show cell commands. In the desktop app, use Ctrl+1 on Windows with the picture selected, then look for the size and properties controls. In Excel for the web, open the workbook in the desktop app if the placement options are unavailable.

The image moves when I sort or filter rows. The setting is not a way to attach an image to a record. For a picture that should remain associated with a specific row, use Excel’s picture-in-cell feature where available, or use Move and size with cells and test the sort behaviour on a copy of the sheet. Decide whether the picture should stay fixed on the sheet or travel with the data; those are different goals.

The picture looks fixed but prints in the wrong place. Check the print area and page layout using File > Print. The image may be outside the intended range, overlap another object, or appear differently when the page is scaled. Adjust its location or size on the sheet, then preview again before printing.

The image disappears behind cells or another object. Pictures are floating objects layered over the worksheet. Open the Selection Pane and select the image by name. If it is behind another object, use the pane’s ordering controls or the Picture Format arrangement options to change its position in the object stack.

Frequently Asked Questions

Which Excel setting stops a picture moving with cells?

Select the picture, open Format Picture > Size & Properties > Properties, and choose Don’t move or size with cells. This stops cell-size changes from moving or resizing the picture.

Can I keep the image fixed but still resize it manually?

Yes. The setting controls how the picture responds to worksheet cell changes, not whether you can edit it. Select the image and drag a corner handle or enter a size in the Picture Format controls.

Does the picture stay in the same place when I scroll?

No. The picture remains at its location on the worksheet, so scrolling the sheet moves it in and out of view. The setting does not pin an image to the Excel window.

Will an image set not to move with cells follow a sorted row?

Do not rely on it to follow a specific record. A floating picture is independent of cell contents. Use a picture placed in a cell if the image needs to belong to a record, and verify the behaviour in your Excel version before sorting important data.

Can I insert a picture without covering the cell contents?

A floating picture sits above the grid and can cover cells. Make space by adjusting the layout, reduce or reposition the image, or choose a cell-based picture if it suits the job. Check the worksheet at normal zoom and in Print Preview.

Do the instructions work in Excel for the web?

You can insert pictures in Excel for the web, but the desktop app may provide more complete placement controls. If you cannot locate the Properties options in the browser, open the workbook in the desktop version and set the picture property there.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.