Formatting Issues

Fix Excel Pictures Moving or Resizing Incorrectly After Sorting

Tauseeq MagsiTauseeq Magsi Nov 2, 2026 869 views

Question details

The user needs to prevent inserted pictures from improperly resizing, moving, or overlapping when applying sort and filter actions to rows.

How to Fix Excel Pictures Moving or Resizing Incorrectly After Sorting and Filtering
Product
Excel
Device & OS
not provided
Scenario
Managing a workbook where cells contain pictures and wrapped text, and sorting or filtering is applied to the data table.
Observed behavior
Pictures resize, overlap, or move out of their original cells after sorting and filtering, especially when row heights vary or are dynamically adjusted.
Before you start

Ensure all pictures are scaled to fit entirely within their respective cell borders before attempting to sort or filter the data, as overlapping edges are a primary cause of image displacement.

Solution 1Recommended

Modify Picture Properties and Fit Images Inside Cells

Adjusting the object positioning properties prevents Excel from stretching, shrinking, or displacing the image when rows are filtered or resized.

Excel handles picture placement based on the cell edges. If an image crosses a cell boundary, sorting the data will cause unpredictable overlapping. Setting the correct object properties ensures the image respects the row's movement.

1
Resize the picture completely within the cell

Select the inserted image and use the sizing handles to scale it down. Ensure there is a small gap between the image edges and the cell borders on all four sides.

2
Open the Format Picture pane

Right-click the adjusted picture and select 'Size and Properties' from the context menu to open the formatting side panel.

3
Adjust the Object Positioning

Expand the 'Properties' section. Select 'Move but don't size with cells' if your row heights might change, or select 'Move and size with cells' only if your cell dimensions are permanently locked.

Modify Picture Properties and Fit Images Inside Cells
Batch Apply Settings: You can select multiple pictures at once by holding the Ctrl key while clicking them, then apply the 'Move but don't size with cells' property to all of them simultaneously.

Manage Pictures and Data Tables Easily with WPS Spreadsheet

WPS Spreadsheet offers precise image positioning controls and seamless compatibility with Excel formats, making it easy to sort and filter data without breaking your visual layout.

  1. 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx file containing the data table and images.
  2. 2. Select the images: Click to select the image inside the cell, or hold Ctrl to select multiple images at once.
  3. 3. Access Object Properties: Right-click the selected images, choose 'Format Object', and navigate to the Properties tab in the right-hand pane.
  4. 4. Lock the positioning: Choose 'Move but don't size with cells' to keep images perfectly intact and properly aligned during any sorting or filtering actions.
Fully compatible with Microsoft Excel (.xlsx) formats and features.Advanced picture property controls to lock aspect ratios and cell positions accurately.Lightweight software that handles large data tables with embedded images smoothly.Free to use with a familiar, user-friendly interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel pictures bunch up at the top when I filter rows?

This usually happens when pictures overlap the cell borders or when their properties are set to 'Don't move or size with cells'. To fix this, ensure all images are completely inside their cell boundaries and set their properties to 'Move and size with cells' or 'Move but don't size with cells'.

Can I use formulas to adjust row heights for pictures automatically?

While using formulas like REPT(CHAR(10),x) can create line breaks to expand cells visually, it can cause unstable resizing behavior when sorting or filtering data. It is highly recommended to use standard, fixed row heights for any tables containing embedded images.

Is it better to insert pictures into cells or leave them as floating objects?

If your images correspond to specific data rows that will be sorted or filtered, you must insert them directly over the corresponding cells and properly configure their positioning properties to move with the cells. Floating objects will remain in place and will not move with the sorted data.