Formatting Issues

How to Remove an Extra Box or Object from an Excel Worksheet

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to delete an unwanted box, shape, form control, or floating object from their worksheet.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Cleaning up a worksheet that contains unwanted floating shapes, text boxes, or form controls outside of standard cell data.
Observed behavior: An extra box or object appears on the spreadsheet and resists standard cell deletion methods.

Before you start

Before attempting bulk deletion of objects, save a copy of your workbook to ensure you do not accidentally delete necessary charts, buttons, or form controls.

Solution 1Recommended

Use Go To Special to Select and Delete Objects

This is the most efficient method to highlight and remove all floating objects, especially if they are difficult to click or transparent.

The 'Go To Special' feature allows you to bypass cell data and specifically target floating elements like text boxes, shapes, and form controls across the entire active sheet.

Open Go To Dialog

Press 'Ctrl + G' on your keyboard to open the Go To dialog box, then click the 'Special...' button at the bottom.

Select Objects

In the Go To Special window, select the 'Objects' radio button and click 'OK'. This will highlight every object on your current worksheet.

Delete Selected Objects

With the objects highlighted by resize handles, press the 'Delete' key on your keyboard to remove them simultaneously.

Watch out for Charts: This method will also select charts and graphs. If you have charts you want to keep, hold the 'Ctrl' key and click them to deselect before pressing Delete.

Solution 2

Manually Select and Delete the Border

Best for isolating and removing a single, visible shape or box without affecting other worksheet elements.

Solution 3

Check Sheet Protection and Object Grouping

If the object cannot be clicked or selected, it may be locked behind sheet protection, grouped with other items, or part of data validation.

Manage Spreadsheets Easily

Seamlessly Manage Objects and Spreadsheets with WPS Office

WPS Spreadsheet offers a highly intuitive interface to find, manage, and edit floating objects, form controls, and shapes. It provides professional-grade tools to keep your worksheets clean and formatted exactly the way you want.

1. Open Your Workbook: Launch WPS Spreadsheet and open the file containing the unwanted objects.
2. Use the Select Objects Tool: Go to the 'Home' tab, click on 'Find and Replace', and choose 'Select Objects' to easily click and delete the stubborn box.
3. Alternative Bulk Deletion: Press 'Ctrl + G', click 'Special', select 'Objects', and press 'Delete' to instantly clear all extra boxes.

Fully compatible with Microsoft Excel (.xlsx) formats, ensuring object properties remain intact.Dedicated selection pane to easily locate, hide, or delete transparent or overlapping shapes.Free and lightweight office suite available on Windows, Mac, Linux, iOS, and Android.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I select a shape or text box in my Excel sheet?

The worksheet might be protected, which locks objects from being edited or selected. Go to the Review tab and click 'Unprotect Sheet'. Additionally, the box might actually be a Data Validation input message or a background image, which cannot be clicked like a normal shape.

How do I remove a yellow box that appears only when I click a specific cell?

This is likely a Data Validation input message rather than a floating object. To remove it, select the cell in question, go to the Data tab, click 'Data Validation', navigate to the 'Input Message' tab, and uncheck 'Show input message when cell is selected'.

Can I delete multiple text boxes at once without deleting my charts?

Yes. First, use 'Ctrl + G' > Special > Objects to highlight all objects, including charts. Then, hold down the 'Ctrl' key and click on each of the charts you want to keep. This deselects the charts. Finally, press 'Delete' to remove only the remaining selected text boxes and shapes.

What if the extra box is a macro button or form control?

Form controls and macro buttons can sometimes be difficult to select. You can hold down the 'Ctrl' key while clicking on the button to select it without triggering its assigned macro, then press the Delete key.

Excel & Data Problems