Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Delete Text Box in Excel (3 Easy Ways)

In this article, I will show how to delete text box in Excel in three ways. While working on an Excel worksheet, you need to handle different things. Text boxes are one of these features. You may add a text box in an Excel worksheet for adding texts. Sometimes, you may need to delete them. In this article, I will show the procedures for deleting text boxes. Moreover, I will add important images for your better understanding.


Download Practice Workbook

Please download the workbook to practice yourself.


3 Effective Ways to Delete Text Box in Excel

This is the dataset I am going to use in this article for every method. The dataset contains two columns, B and C, called Name and ID. I will add a text box here in the methods I will describe. Hence, follow the steps of every method one by one to delete the text box. Hopefully, you will enjoy the steps of the methods.

Dataset of how to delete text box in excel


1. Applying Generic Method to Delete Text Box in Excel

In this method, I will delete text box in a generic way. This method is very simple. As you can see, I have added a text box under the dataset. Follow the steps one by one to delete the text box. The method is manual. So, apply the method carefully.

Using Generic way to delete text box in excel

Steps:

  • First, select the text box.

Using Generic way to delete text box in excel

  • Then, press the Backspace or Delete button to delete the text box.
  • As a result of this action, excel will delete the text box. You will have the result like the picture given below.

Using Generic way to delete text box in excel

This is the method to delete the text box in a generic way.

Read More: [Solved] Excel Text Box Not Showing (3 Reasons & Solutions)


2. Using Excel Go to Option to Delete Text Box

In this method of this article, I will show the procedures to delete text box in Excel by using the go to option. You can see the text box below the dataset. Follow the method step by step given below. Hopefully, this method will help you to increase your Excel skill.

Using Go to option to delete text box in excel

Steps:

  • First, press the Ctrl + G button to open the go to window.
  • Consequently, the go to window will open.
  • Then, select the Special option from the window.

Using Go to option to delete text box in excel

  • Then, from the Go To Special window, select the Object option.
  • After that, press Ok.

Using Go to option to delete text box in excel

  • As a result, Excel will select all the text boxes in your sheet.

Using Go to option to delete text box in excel

  • Then, press the Backspace or Delete button to delete the text box.
  • As a result, the text box will be deleted.

Using Go to option to delete text box in excel

This is the process to delete text box in excel by using Go To option.

Read More: How to Insert an Embedded Text Box in Excel (4 Easy Ways)


Similar Readings


3. Implementing VBA to Delete Text Box

In this method, I will implement a VBA code to delete text box in excel. This is a very short and smart way. I hope this method will take your excel skill to the next level. You will find the text box added below the dataset. Follow the steps one by one.

Implementing VBA to Delete Text Box in excel

Steps:

  • Press Alt + F11 simultaneously on your keyboard.
  • As a result, Microsoft Visual Basic for Application window will appear.

Implementing VBA to Delete Text Box

  • Then, select the Module option to open a new module.

  • After that, copy the following VBA code into your module.
Sub DeleteAllTextBoxes()
ActiveSheet.TextBoxes.Delete
End Sub

Here, we used DleteAllTextBoxes() function to delete all the text boxes from a particular excel sheet.

  • Then, press the Run button to run the code.

  • As a result, Excel will delete all the text boxes of our working sheet.

By using a VBA code, you can delete a text box from a particular worksheet in this particular way.

Read More: How to Edit Text Box in Excel (2 Simple Ways)


Things to Remember

  • In the second and third methods, all the text boxes will be deleted from an Excel worksheet. So, if you want to delete a particular text box, you need to select it manually and follow the first method only.

Conclusion

In this article, I have tried to explain how to delete text box in Excel. I hope, you have learned something new from this article. Now, extend your skill by following the steps of these methods. You will find such interesting blogs on our website Exceldemy.com. I hope you have enjoyed the whole tutorial. If you have any queries, feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo