Can Excel Move Objects with Columns but Not Rows?
Question details
The user wants to know if it is possible to configure object properties so that an image or chart moves when columns are resized, but stays stationary when rows are filtered.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Managing the layout of floating objects like charts, shapes, or images in a spreadsheet where row filtering is frequently used.
- Observed behavior
- Excel's built-in placement settings apply to rows and columns simultaneously. There is no independent control to link an object's movement exclusively to columns while ignoring row changes.
Determine the exact layout of your data table and identify where you plan to apply filters, as this will help you choose the best permanent location for your visual objects.
Place the Object Outside the Filtered Row Range
Since Excel does not separate row and column movement properties, placing objects away from affected rows is the most reliable method to prevent layout distortion.
Excel's 'Format Picture' or 'Format Chart Area' properties only offer three combined options: Move and size with cells, Move but don't size, and Don't move or size. None of these isolate column movement from row movement.
To prevent objects from collapsing or moving unexpectedly when filtering rows, you must place them in an area where row heights remain constant, such as the top of the worksheet.
Click on the image, shape, or chart you want to protect from row filtering.
Drag the object to the top rows of your spreadsheet (e.g., Rows 1 to 5), ensuring it sits entirely above your data headers.
Right-click the object, select 'Size and Properties' or 'Format Object', and choose 'Don't move or size with cells' under the Properties tab to lock it completely.

Move Objects to a Separate Dashboard Worksheet
Keep your raw data and your visual objects completely separated on different worksheets to avoid layout conflicts entirely.
Experience Seamless Spreadsheet Management with WPS Office
Dealing with strict layout limitations in Microsoft Excel can be frustrating. WPS Office provides a free, lightweight, and highly compatible alternative that makes formatting, filtering, and organizing your data effortless. With an intuitive interface, you can manage objects, build dashboards, and handle large datasets without expensive subscriptions.
- 1. Download WPS Office: Visit the official WPS website to download and install the free office suite on your device.
- 2. Open your Excel files: Launch WPS Spreadsheets and click 'Open' to select your existing .xlsx workbooks.
- 3. Edit with ease: Enjoy immediate formatting compatibility and effortlessly manage your data, charts, and objects.

Frequently Asked Questions
What does 'Move and size with cells' do in Excel?
This default property links a floating object (like a chart or picture) to the cells directly beneath it. If the rows or columns under the object are resized, hidden, or filtered, the object will stretch, shrink, or move accordingly.
How do I access object placement properties in Excel?
Right-click your image, shape, or chart, and select 'Size and Properties' or 'Format Object'. Expand the 'Properties' section in the right-side format panel to view and change the placement options.
Can I lock a chart's position so it never moves?
Yes. Right-click the chart, choose 'Format Chart Area', go to 'Size & Properties', and select the 'Don't move or size with cells' option. The chart will remain fixed on the screen regardless of any row or column changes.
Why does my chart disappear when I filter data?
This happens if the chart is placed over rows that get hidden by your filter, and its property is set to 'Move and size with cells'. To fix this, change the object property to 'Don't move or size with cells' or move the chart to rows that are never filtered.




