Excel Guides

Deleting Graphics when Deleting a Row in Excel

When you delete a row in Excel, any graphics associated with that row are also deleted. This is because graphics are anchored to cells, and when you delete a row, the cells are also deleted. If you want to keep the graphics but delete the row, you need to unanchor the graphics first.

To unanchor a graphic, select it and then click the Format tab. In the Arrange group, click Position and then click More Layout Options. In the Layout dialog box, click the Advanced button. In the Advanced Layout dialog box, clear the Move object with cells check box and then click OK twice.

Now when you delete the row, the graphic will remain in place.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.