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

Get FREE Advanced Excel Exercises with Solutions!

In this article, I will show how to delete a 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.


How to Delete Text Box in Excel: 3 Easy Ways

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 the 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 with its border in a generic way.

Read More: How to Edit Text Box in Excel


2. Using Excel Go to Option to Delete Text Box

In this method of this article, I will show the procedures to delete text boxes 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 skills.

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 of deleting text boxes in Excel by using the Go To option.

Read More: How to Align Text Boxes in Excel


3. Implementing VBA to Delete Text Box

In this method, I will implement a VBA code to delete the text box in Excel. This is a very short and smart way. I hope this method will take your Excel skills 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, the 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.


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.

Download Practice Workbook

Please download the workbook to practice yourself.


Conclusion

In this article, I have tried to explain how to delete a 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. 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


<< Go Back to TextBox | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Souptik Roy
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

2 Comments
  1. HI.thanks a lot

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo