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
- Delete all text boxes in active worksheet with VBA code
- Delete all text boxes in active worksheet, selected sheets or workbook with a handy feature
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.
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:
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.
After installing Kutools for Excel, please do as this:
1. Click the Kutools > Delete > Delete 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.
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 Pictures In A Range Of Cells
- If there are multiple pictures populated into your worksheet, now, you want to delete some of them in a specified range, how do you deal with it quickly?
- 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.