How to delete a text box that cannot be deleted in an Excel worksheet

Step 1. As shown in the following figure, there may be several patterns, images, command buttons, text boxes, and dialog boxes in the excel table, especially when the VBA code is incorrectly used, many similar content may be automatically copied, you need to delete these objects in batches.

Step 2. Press the keyboard shortcut Ctrl + G or F5 to bring up the "positioning" dialog box and click the "positioning condition" button in the lower left corner.

Step 3: Select objects in the lower-left corner and click OK.

Step 4. At this time, you will find that some objects are located and selected. First, press the Del key on the disk to delete these objects. Others are deleted using other methods.

Step 5: delete part of the content according to the positioning method and the result is shown in the figure below. The remaining parts are not located.

Step 6: press Alt + F11 to enter the VBE interface. Click the blue triangle pattern in the upper right corner to enter the design mode or edit mode. In this status, objects can be modified or deleted.

Step 7: return to the excel worksheet page. Repeat the previously used locating method to locate all the objects. Click Del to delete them.