Note: The other languages of the website are Google-translated. Back to English

How to quickly delete all text boxes in Excel?

Are there tricks to delete multiple Text Boxes in workbook? It is time-consuming to delete each Text Box one by one. Actually, there are several ways can help you quickly delete all text boxes:


Delete all text boxes or other objects in active worksheet with Go To function

1. Click F5 or Ctrl+G to display the Go To dialog, and then click Special.., see screenshot:

2. In the popped out Go To Special dialog box, select Objects, and then click OK button, see screenshot:

3. And all the objects in current worksheet have been selected at once, see screenshot:

4. Then, you just need to press the Delete key on the keybord to remove all these text boxes as well as other objects.

Note: This method will not only delete all text boxes, but also delete all kinds of shapes in active worksheet, including pictures, ClipArt, Shapes, SmartArt, charts, etc.

Delete all text boxes in active worksheet with VBA code

Sometime you may want to delete only the text boxes, but remains other shapes, such as charts, pictures, a VBA macro will be a good choice to delete all text boxes only in active worksheet, please do with the following steps:

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following macro in the Module window.

VBA code: Delete all text boxes from current worksheet:

Sub DeleteAllTextBoxes()
ActiveSheet.TextBoxes.Delete
End Sub

3. Press the F5 key to run this macro, and only the text boxes in current worksheet are deleted, see screenshots:


Delete all text boxes in active worksheet, selected sheets or workbook with a handy feature

Kutools for Excel's Delete Illustrations & Objects can help you to delete only the text boxes in active worksheet, selected worksheets or the whole workbook without affecting other shapes.

Note:To apply this Delete Illustrations & Objects, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.

After installing Kutools for Excel, please do as this:

1. Click the Kutools > DeleteDelete Illustrations & Objects, see screenshot:

2. In Delete Illustrations & Objects dialog box, check the Text Boxes option, and then specify the scope where you want to delete the text boxes from, see screenshot:

3. Then, click OK. And all the text boxes will be removed at once in active worksheet, selected worksheets, or the whole workbook according to the options you checked.

Tips: Kutools for Excel's Illustrations & Objects feature can help us delete all 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 as you need.  Click to know more…

More relative articles:

  • Delete All Pictures Or Other Objects In Excel
  • If you want to delete all pictures from Microsoft Excel, it may be time-consuming to select each picture and delete them one by one. The following tricks may ease your work to delete all pictures.
  • Delete All Hidden Rows Or Columns In Excel
  • If you have a large workbook with a lot of hidden rows and columns, and now the hidden data are unavailable, you would like to delete all of them. How could you quickly delete them?
  • Delete Multiple Empty Columns Quickly In Excel
  • Sometimes when you import data to Microsoft Excel from some source, such as web page, CSV, text, etc., there may be many empty columns with it. It must be time-consuming to delete each empty column one by one. Therefore, some of us search for easy ways to solve this problem. This article collects some tricky tips to help you delete multiple empty columns quickly.

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Comments (25)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Yes working fine. Thanks
Naresh
This comment was minimized by the moderator on the site
Delete all text boxes in active worksheet with Go To function in Excel >>>>>>Wonderful. It worked like a magic.
Srikanth
This comment was minimized by the moderator on the site
Super ma!!! Go to function rocks.
Manikandan
This comment was minimized by the moderator on the site
wonderful............... you have saved a lot of time for me thankyou very much........
kiran
This comment was minimized by the moderator on the site
Thanks a lot. It saved lot of time and I became famous
Subramanya BS
This comment was minimized by the moderator on the site
Thank you! I've searched all over the interent for a solution. Everybody was giving complicated solutions (even Office official page). Very simple resolution and very efficient. It worked.
Diana
This comment was minimized by the moderator on the site
Really helpful! Thank you very much.
ivarmada
This comment was minimized by the moderator on the site
HA, a 7 row excel sheet with over 43000 textboxes after migration to Excel 2013 from 2010. No wonder my pc kept crashing... I can't even get Go To to delete them..... At least I know what to do with them.. gotta find more processing power!
Mike
This comment was minimized by the moderator on the site
GoTo Script INSTANTLY solved my problem. Now I can complete my grade book. THANK YOU, EXTENDOFFICE !
WG Johnson
This comment was minimized by the moderator on the site
Love you :)
Graham Hyland
This comment was minimized by the moderator on the site
Thank you!
Barb
This comment was minimized by the moderator on the site
Thank You So much
Arjun Arya
This comment was minimized by the moderator on the site
Hello,
I had an excel workbook with 10 tabs and on each tab 1000 textboxes or so...
I renamed the xlsx to zip, then removed the drawings xml files.
renamed back to xlsx, open, then excel will tell you that there is something wrong with the file. Press repair, et voila, all the textboxes are gone.
greets
Mattie
Mattie
This comment was minimized by the moderator on the site
Amazing trick, I'm wondering how the f*ck you figured this one out!
Nemida
This comment was minimized by the moderator on the site
this saved my life
Thaisa
This comment was minimized by the moderator on the site
Thanx so much! I got stuck with a copied check boxes from the internet onto spreadsheet and pressing delete button just couldn't get rid of them. In desperate in looked up for the solution and found yours. Worked like magic!
S P
This comment was minimized by the moderator on the site
Thanks bro
Pencho Slaveikov
This comment was minimized by the moderator on the site
awesome!!!! thanks alot!!!! this is soooo cool.
Abby
This comment was minimized by the moderator on the site
GOD BLESS YOU!!!! WAS AN ANNOYING FREAKING OBJECT!!! Problem Solved!!!!
n/a
This comment was minimized by the moderator on the site
delete text box but keep the value is possible
Gaurang
This comment was minimized by the moderator on the site
useful article.
Navin kumar
This comment was minimized by the moderator on the site
the VBA system worked for me 6 months ago but now giving a 'run time error' out of memory. Reseted computer with only the excel open and nothing running heavy in the background. Any clues?
michael
This comment was minimized by the moderator on the site
Thank you very much.

It was textboxes that slowed my excel sheet
Olesen
There are no comments posted here yet
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0  Characters
Suggested Locations