Deleting All Graphics

Summary: Need to delete all the graphics in a worksheet? It's easy to do when you use the Go To Special dialog box. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Excel allows you to easily add graphics to a worksheet. This can be helpful, at times, but at other times you may want to delete all the graphics in a worksheet. The easiest way to delete all the graphics is to follow these steps:

Press F5 to display the Go To dialog box.
Click on the Special button. Excel displays the Go To Special dialog box. (Click here to see a related figure.)
Make sure the Objects radio button is selected.
Click on OK. All the graphics in your worksheet are selected.
Press the Del key. All the graphics are deleted.

This solution works only if there are no other objects (besides graphics) in your worksheet. If you have other objects that you don't want deleted, then all you need to do is perform steps 1 through 4, and then hold down the Ctrl key as you use the mouse to click on each object you don't want deleted. When you are satisfied with the objects selected, finish up by following step 5.

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

Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.

Check out ExcelTips Premium today!