Office Settings & Configuration

Can Excel Move Objects with Columns but Not Rows?

John WilsonJohn Wilson Nov 11, 2026 868 views

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.

Can Excel Move Objects with Columns but Not Rows?
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the object

Click on the image, shape, or chart you want to protect from row filtering.

2
Move to a safe zone

Drag the object to the top rows of your spreadsheet (e.g., Rows 1 to 5), ensuring it sits entirely above your data headers.

3
Lock the object properties

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.

Place the Object Outside the Filtered Row Range
Use Freeze Panes: You can use the 'Freeze Panes' feature under the View tab to keep the top rows containing your objects permanently visible while you scroll through the filtered data below.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install the free office suite on your device.
  2. 2. Open your Excel files: Launch WPS Spreadsheets and click 'Open' to select your existing .xlsx workbooks.
  3. 3. Edit with ease: Enjoy immediate formatting compatibility and effortlessly manage your data, charts, and objects.
Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Free to use with a lightweight installation that won't slow down your computer.Familiar tabbed interface allows for seamless migration with zero learning curve.Advanced chart and object formatting options to build beautiful, responsive dashboards.
microsoft office alternative - wps office

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.