How to Lock Images in Excel So They Don’t Move When You Sort or Filter

1. Why Images Move When You Sort or Filter in Excel

When you insert a picture into Excel, it is added as a floating object, not as part of the cell itself. Floating objects sit on top of the worksheet grid and are not automatically tied to row or column behaviour. As a result, when rows are sorted or filtered, the data moves but the images may stay behind, overlap, or stack on top of each other.

Excel controls this behaviour through object positioning settings, which determine whether an image moves with cells, resizes with cells, or remains fixed in place regardless of changes.

2 Why Locking Images in Excel Is Useful

Locking images is especially valuable in business and training spreadsheets where images must stay aligned with related data. Common use cases include:

• Product lists with photos
• Training registers with participant images
• Inspection or audit sheets with evidence photos
• Dashboards with icons or visual indicators

When images are locked correctly, they sort, filter, hide, and move with their rows, maintaining data integrity and preventing confusion. This results in spreadsheets that are easier to read, more professional, and less prone to errors during analysis.

3. The Key Excel Setting That Controls Image Behaviour

Excel provides three object positioning options for pictures and shapes:

• Move and size with cells – the image moves and resizes when the cell changes
• Move but don’t size with cells – the image moves with the row but keeps its size
• Don’t move or size with cells – the image stays fixed on the sheet

For sorting and filtering scenarios, Move and size with cells is the most reliable option, as it ensures the image remains associated with its row when data is rearranged. [excelribbon.tips.net], [exceldemy.com]

4. How to Lock Images So They Move with Sorting and Filtering

The following method uses Excel’s built‑in Format Picture settings:

1. Select the image (or select multiple images using Ctrl + click)
2. Right‑click the image and choose Size and Properties or Format Picture
3. Open the Size & Properties section
4. Expand Properties
5. Select Move and size with cells

Once applied, the image will move and remain aligned when rows are sorted or filtered.

5. Common Mistakes That Cause Images to Misalign

Even with the correct setting applied, images can still behave unexpectedly if:

• The image overlaps multiple rows or columns
• Rows have inconsistent heights
• Images were copy‑pasted from other files with different properties
• Images are placed outside the data range being sorted

Microsoft support discussions note that images should fit entirely within a single row to ensure reliable sorting and filtering behaviour.

6. Best Practice for Working with Images in Excel Tables

To keep image‑based spreadsheets stable and easy to maintain:

• Resize images to fit fully inside one cell
• Apply Move and size with cells immediately after inserting images
• Keep row heights consistent
• Avoid merging cells where images are used
• Test sorting and filtering before sharing the file

These practices are commonly recommended in Excel troubleshooting guides for image alignment issues.

7. Conclusion

Images in Excel do not automatically behave like cell content, which is why they often move or overlap when sorting and filtering. By adjusting a picture’s object positioning to Move and size with cells, you can lock images to their data and ensure your spreadsheet remains accurate, readable, and professional. This small setting change can prevent significant layout problems, especially in image‑heavy workbooks.