Fix Excel Pictures Moving or Resizing Incorrectly After Sorting
Question details
The user needs to prevent inserted pictures from improperly resizing, moving, or overlapping when applying sort and filter actions to rows.

- 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.
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.
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.
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.
Right-click the adjusted picture and select 'Size and Properties' from the context menu to open the formatting side panel.
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.

Maintain Consistent Row Heights
Using uniform row heights prevents the calculation errors that cause pictures to shift unexpectedly during a sort.
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. Open your workbook in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx file containing the data table and images.
- 2. Select the images: Click to select the image inside the cell, or hold Ctrl to select multiple images at once.
- 3. Access Object Properties: Right-click the selected images, choose 'Format Object', and navigate to the Properties tab in the right-hand pane.
- 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.

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.




