Delete All Charts, Text Boxes and Embedded OLE Objects in Excel 2007/2010

When you need to delete all the unwanted objects such as the charts, text boxes and embedded OLE objects in the worksheets, you are not able to do it quickly but have to delete them one by one. The Delete Tools in Kutools for Excel can help you quickly delete all of them in one click.

With Delete Tools, you can delete charts, lines, pictures, auto shapes, smart arts, text boxes, linked OLE objects and embedded OLE objects in active worksheet, selected worksheet or all worksheets of the current workbook.

1. Click "Kutools">> "Edtting" group>>Delete Tools. See screenshot (Fig.1)

Fig. 1 Delete Tools

Usage:

2.1. Select the items you need to delete, such as Charts, Pictures, Lines, Text boxes in the pop-up dialog box. The check box supports multiple-selecting.

2.2. Specify the scope you want to delete the items, you can choose to delete them in active sheets, selected sheets or all sheets. See screenshot (Fig.2)

shot-delete-tool-2

Fig. 2 The dialog box of Delete Tools

3. Click OK to apply it.