Deleting Graphics when Deleting a Row

Summary: If you use Excel to keep a graphic with each row of data you amass, you may wonder if there is a way to easily delete the graphic with each row you delete. Fortunately, there is a way, and all it takes is to make one small setting change to your graphics. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Sethuraman has a worksheet where column A contains names, column B contains addresses, and column C contains a photo of the person. If he deletes the row, the photo remains. He wonders how the photo can be deleted at the same time the row is deleted.

This happens because of the way that the properties for the graphics are set up. If the only graphics in the worksheet are those for the people, then start by selecting all the graphics. (Press F5, click Special, select Objects, click OK.) Then, follow these steps to set the properties for all the selected graphics:

Right-click one of the graphics. Excel displays a Context menu.
Choose either Format Picture or Size and Properties from the Context menu, depending on your version of Excel. Excel displays either the Format Picture or Size and Properties dialog box.
Make sure the Properties tab is displayed. (Click here to see a related figure.)
Make sure the Move and Size with Cells check box is selected.
Click OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (5414) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

A Picture is Worth Thousands! Your worksheets are not limited to holding numbers and text. You can also add graphics or easily create charts based on your data. Excel Graphics and Charts, available in two versions, helps you make your graphics and charts their absolute best.

Check out Excel Graphics and Charts today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Deleting Graphics when Deleting a Row