1. We start excel2007 and open a test file with controls inserted. To delete these controls in batches, click the menu bar-Start-Search and select. 2. Click the find and select button to pop up the drop-down menu, and then click the location condition option. 3. Pop-up dialog box of positioning conditions, check the object and click OK. 4. At this time, the control object in the table will be selected at one time, and the delete key on the keyboard will be pressed to delete it. In this way, the text and control objects in Excel tables were successfully deleted in batches.