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

Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.

Check out ExcelTips: Filters and Filtering today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Deleting Graphics when Deleting a Row