How to Remove Drawing Tools in Excel (3 Easy Methods)

In this tutorial, I am going to show you 3 easy methods to remove drawing tools in excel. A lot of times when you copy any data from other sources, there might be a lot of unnecessary shapes and objects. You can use the methods that I will explain in the following section to clear these objects.


Download Practice Workbook

You can download the practice workbook from here.


Drawing Tools in Excel

Drawing in excel means making any shape. All of these shapes, text boxes, and other objects are called Drawing Tools. We may keep or remove excel drawing tools as per our needs. In excel, there are both predefined drawing tools and also freeform drawing options. Both of these tools are very useful in making the data look more visual. Note that excel charts also fall in this category of drawing tools that you can use when needed.


3 Easy Methods to Remove Drawing Tools in Excel

The dataset that we will use to remove the drawing tools contains various shapes as excel objects. We have taken multiple shapes to show the power of the methods to work with a large number of objects in no time.

how to remove drawing tools in excel


1. Using Go To Special Feature

The Go To Special feature in excel allows you to quickly find and select any item that meets certain criteria. We will use this feature to remove drawing tools from our excel worksheet.

Steps:

  • First, go to the tab Home.

how to remove drawing tools in excel

  • Then, go to the Editing section and click on the drop-down Find & Select.
  • Here, select Go To Special.

how to remove drawing tools in excel

  • Now, in the Go To Special window, select Objects and press OK.

how to remove drawing tools in excel

  • As a result, this will find and select all the objects that are present in the current worksheet.

  • Finally, press Delete and excel will remove all the shapes.

Read More: How to Use Drawing Tools in Excel (2 Easy Methods)


2. Utilizing Selection Pane in Excel to Remove Drawing Tools

We can select and remove any drawing tools with the help of the Selection Pane in excel. This option will give us a list of all the available objects on our worksheet and then we can remove them very easily. Let us see how to use it.

Steps:

  • To begin with, navigate to the tab Page Layout.

Utilizing Selection Pane in Excel to Remove Drawing Tools

  • Now, under the Arrange section, click on Selection Pane.

Utilizing Selection Pane in Excel to Remove Drawing Tools

  • Here, in the Selection window, you will see the list of all available objects.
  • Finally, select any of them or all of them and press the Delete key to remove them from the worksheet.


Similar Readings


3. Remove Drawing Tools Using VBA Code in Excel

If you have a large number of drawing tools in excel that you want to remove from a large number of worksheets, then using VBA would be the best option. Follow the steps below.

Steps:

  • First of all, navigate to the Developer tab and click on Visual Basic.

Remove Drawing Tools Using VBA Code in Excel

  • Next, in the Visual Basic window, go to Insert and click on Module.

Remove Drawing Tools Using VBA Code in Excel

  • Now, in the new Module1 window, type in the following code:
Sub Delete_Drawing_Tools()
Dim obj As Shape
Dim wbook As Workbook
Dim wsheet As Worksheet
'Go through all worksheets
For Each wsheet In ActiveWorkbook.Worksheets
'Loop through the objects of the current worksheet
For Each obj In wsheet.Shapes
'Remove object
obj.Delete
Next obj
Next wsheet
End Sub

Remove Drawing Tools Using VBA Code in Excel

  • After that, close the Visual Basic window and go to the tab Developer.
  • Here, click on Macros.

  • Consequently, this will open a new window of the Macro list that are available in the workbook.
  • Here, select the macro we just created and click on Run.
  • Immediately, this will delete all the objects from all the worksheets.

Read More: How to Remove Unwanted Objects in Excel (4 Quick Methods)


How to Hide Drawing Tools

Sometimes you may not want to remove the drawing tools or objects in excel altogether. Rather you want to hide them. This method can help you in doing that.

Steps:

  • To begin with, go to the tab Page Layout.

how to remove drawing tools in excel

  • Then, navigate to the Arrange section and select the Selection pane.

how to remove drawing tools in excel

  • Now, in the Selection window, you should see the list of all the objects.
  • Finally, click Hide All to hide all the objects or hide an individual object by clicking on the Eye icon next to it.


Things to Remember

  • The methods above can be used equally to remove any text boxes.
  • Make sure to type the VBA syntaxes properly, otherwise, it won’t work.
  • Keep in mind that when you run the VBA macro, it will remove all the objects from each worksheet and not only the current sheet.

Conclusion

I hope that you understood the methods I showed in this tutorial on how to remove drawing tools in excel. I would recommend you to go through the suggested steps of each method multiple times and understand them very well. Also, download the practice workbook and try adding more objects to test yourself.  Lastly, to learn more excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.


Related Articles

Nazmul Hossain Shovon

Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo