Delete All Charts, Text Boxes, and Embedded OLE Objects in Excel 365!!
Tags: kutoolsexceltutorial, stepstodeleteallobje, kutools
Published: 2020-11-07 04:19:08

---
title: Delete All Charts, Text Boxes, and Embedded OLE Objects in Excel 365!!
published: true
date: 2020-11-06 12:09:28 UTC
tags: KutoolsExcelTutorial,StepstoDeleteallobje,Kutools
canonical_url: https://geekexcel.com/delete-all-charts-text-boxes-and-embedded-ole-objects-in-excel-365/
---

In this tutorial, we will guide you to learn the steps to **Delete All Charts, Text Boxes, and Embedded OLE Objects** in **Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Delete All Charts, Lines, Pictures, Shapes, Smart arts, and Text boxes:

To remove all charts, pictures, shapes, etc in the spreadsheet, follow the below instructions.

- First, you need to **open the worksheet** which contains charts, pictures, lines, text boxes, etc.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-15.png)<figcaption id="caption-attachment-16860">Example</figcaption>

- On the **Kutools Tab, select** the **Delete** option, then **choose** the **Delete Illustrations**  **& Objects** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-2.png)<figcaption id="caption-attachment-16861">Kutools Tab</figcaption>

- Now, it will open the **Delete Illustrations & Objects Dialog Box**.
- In that dialog box, you need to **select the items (charts, pictures, lines, text boxes, smart arts, etc)** that you want to delete.
- Then, you need to **choose** the **scope** you want to delete items. You can choose the **Active sheet, Selected sheets,** or **All sheets** option.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-4.png)<figcaption id="caption-attachment-16865">Click the OK button</figcaption>

- Finally, **click** the **OK** button.
- You can see that all the items you selected have been deleted from the worksheet as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-7.png)<figcaption id="caption-attachment-16866">Result</figcaption>

## Remove Embedded OLE or Linked OLE Objects:

If you want to delete embedded OLE objects or linked OLE objects, then follow the below steps. Let’s see what is Embedded OLE and Linked OLE objects.

**Embedded OLE Objects: ** It is a copy of information from another document or file. If any changes made to the source document are not reflected in the destination document because there is no link between them.

**Linked OLE Objects: ** It is a reference to the information located in another document. If you change the source data, you need to update the links instead of updating the document or file that contains OLE objects.

- You need to **open the worksheet** that contains Embedded OLE or Linked OLE objects. For example, we have shown the worksheet with an embedded OLE object in the below image.

![Example object](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-3.png)<figcaption id="caption-attachment-16869">Example object</figcaption>

- On the **Kutools Tab, select** the **Delete** option, then **choose** the **Delete Illustrations**  **& Objects** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-2.png)<figcaption id="caption-attachment-16861">Kutools Tab</figcaption>

- Now, it will open the **Delete Illustrations & Objects Dialog Box**.
-  You need to **select** the **Embedded OLE objects** and **Linked OLE objects** options that you need to delete.
- Then, in the **look in** section, you can choose any one of the options such as **Active sheet, Selected sheets,** or **All sheets.**
- Then, **click** the **OK** button.

![Delete Illustrations & Objects Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-1.png)<figcaption id="caption-attachment-16870">Delete Illustrations &amp; Objects Dialog Box</figcaption>

- At last, all the embedded OLE objects or linked OLE objects have been deleted from Excel.

## A Short Synopsis:

In this article, you can easily learn the steps to **Delete All Charts, Text Boxes, and Embedded OLE Objects** in **Excel Office 365** using **Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Generate All Possible Combinations of Certain Lists in Excel 365!!](https://geekexcel.com/generate-all-possible-combinations-of-certain-lists-in-excel-365/)
- [Extract and List All Comments to New Worksheet/Workbook in Excel 365!!](https://geekexcel.com/extract-and-list-all-comments-to-new-worksheet-workbook-in-excel-365/)