The Distorted Graphics
Microsoft Excel is primarily a data management tool, but it is frequently used to build visual dashboards, organizational charts, and product catalogs that rely heavily on inserted images and logos. By default, Excel assumes that any picture you insert into a spreadsheet is logically attached to the specific cells sitting underneath it. If you insert a corporate logo, and later decide to hide a column, adjust a row height, or apply a filter to your data table, Excel will automatically crush, stretch, or completely hide your carefully placed image to match the new dimensions of the cells behind it. This automatic resizing ruins the formatting of professional reports and forces you to constantly reposition your graphics.
How to Lock Picture Size and Position in Excel
To prevent Excel from distorting your images, you must change the individual “Properties” of the image to decouple it from the underlying spreadsheet grid.
1. Open your Excel workbook and locate the problematic image.
2. Right-click the image.
3. Select Size and Properties… (or “Format Picture…” depending on your exact version of Excel) from the context menu.
4. A formatting pane will appear on the right side of your screen.
5. Click the icon that looks like a green square with dimension arrows (the Size & Properties tab).
6. Expand the Properties section by clicking the small triangle next to it.
7. You will see three distinct radio buttons governing how the image interacts with cells:
- Move and size with cells (The default, destructive setting)
- Move but don’t size with cells (The image will shift left/right if you insert columns, but won’t be crushed)
- Don’t move or size with cells (The absolute lock setting)
8. Select the radio button for Don’t move or size with cells.
Once this setting is applied, the image becomes completely independent of the spreadsheet grid. You can delete rows, hide columns, dramatically change row heights, and apply aggressive data filters without the image ever shifting by a single pixel or changing its aspect ratio.
How to Lock Multiple Pictures at Once
If you have a spreadsheet with fifty product photos and don’t want to change the settings one by one:
1. Click on the first image.
2. Hold down the Ctrl key (or Cmd on a Mac) and click on every other image you want to lock, OR press Ctrl + A to select everything if the sheet only contains images.
3. With all images highlighted, right-click any one of them and follow the exact same steps above to select Don’t move or size with cells. The property change will apply to the entire batch simultaneously.