How to Fix Excel Objects Moving After Inserting or Deleting Rows
Question details
Users experience pictures, shapes, or other objects moving to another page or disappearing when adding or removing rows above them.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Editing an Excel spreadsheet that contains inserted objects like pictures or shapes.
- Observed behavior
- Objects unexpectedly shift positions, jump to different pages, or disappear when rows are inserted or deleted.
Before changing application settings, verify if the issue occurs in a single specific workbook or across all your Excel files.
Change Object Properties to 'Move and Size with Cells'
The most common reason for objects shifting unexpectedly is incorrect placement properties. Adjusting this setting ensures objects stay anchored appropriately.
Excel handles graphics and objects as elements floating above the cell grid. By default, their properties dictate how they react when the grid changes. Anchoring them correctly prevents unwanted shifting.
Right-click the picture, shape, or object that is moving unexpectedly.
Choose 'Size and Properties' or 'Format Picture' from the context menu to open the side panel.
Under the Properties tab in the right pane, select 'Move and size with cells' or 'Move but don't size with cells' depending on your layout preference.
Disable Hardware Graphics Acceleration
If objects are visually disappearing or glitching rather than just moving, graphics acceleration might be causing rendering issues.
Run Excel in Safe Mode to Check Add-ins
Third-party add-ins can sometimes interfere with how Excel handles objects, rows, and columns.
Experience Stable Object Handling with WPS Office
If your spreadsheet continues to struggle with rendering objects and shapes, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative that handles complex spreadsheet layouts with ease.
- 1. Download the Installer: Visit the WPS Office website and download the free installation file.
- 2. Install the Software: Run the downloaded file and follow the quick installation prompts.
- 3. Open Your Workbook: Launch WPS Spreadsheet and open your existing Excel file to enjoy stable formatting.
Frequently Asked Questions
Why do my Excel pictures disappear when I hide rows?
If the object's properties are set to 'Move and size with cells', hiding the rows that contain the object will compress its height to zero, making it invisible. To fix this, right-click the object, select 'Size and Properties', and change the property to 'Don't move or size with cells'.
How can I lock an image in Excel so it never moves?
Right-click the image, select 'Size and Properties', and under the Properties section, choose 'Don't move or size with cells'. This anchors the image to the worksheet canvas rather than linking it to the specific cells underneath.
Can workbook corruption cause objects to jump around?
Yes, if a workbook is corrupted, graphical elements might behave unpredictably. You can try copying your data and objects into a brand-new workbook or running an Office online repair from the Windows Control Panel to resolve corruption-related glitches.
