Remove Unwanted Objects and Boxes from Excel Worksheets
Question details
The user wants to remove unwanted boxes and objects copied into an Excel worksheet and prevent them from being added again.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Data from a bank website or downloaded file was copied into a workbook.
- Observed behavior
- Boxes with resize handles appear in the worksheet and may return after deletion.
Click the edge of a box to check whether resize handles appear; these indicate a selectable object rather than cell formatting. Work in a copy of the workbook and identify any charts, pictures, or controls you want to keep before deleting objects.
Remove unwanted objects with the Selection Pane
Use the Selection Pane to identify and delete individual objects without removing every object on the sheet.
In Excel, open the affected worksheet and choose Home > Find & Select > Selection Pane.
Select an item in the pane to locate it on the worksheet. Use the visibility icon beside an item if you need to check which object it represents.
Select an unwanted object in the pane or click its border on the sheet, then press Delete. Repeat for other unwanted objects.

Select and delete all objects on the worksheet
Use Go To Special when the worksheet contains many unwanted objects and you do not need to keep any of its selectable objects.
Paste bank data as text to avoid copying objects
Use a text-only paste or a different download format when bringing the source data into the workbook again.
Remove unwanted worksheet objects in WPS Spreadsheet
Open the workbook in WPS Spreadsheet and delete unwanted selectable boxes directly from the sheet. Paste source data as text when available to avoid bringing objects back.
- 1. Open the workbook: In WPS Spreadsheet, choose Open and select the Excel workbook containing the unwanted boxes.
- 2. Select a box: Click the edge of an unwanted box until its resize handles appear.
- 3. Delete the object: Press Delete, then repeat for any other unwanted boxes.
- 4. Paste replacement data as text: If you need to copy the source data again, select the destination cell and use Paste Special to choose a text option when available. Check that the rows and columns are arranged correctly.

Frequently Asked Questions
Why do boxes appear after I copy data from a website?
The source content can include objects as well as cell data. If a box shows resize handles when you click its edge, select it and press Delete rather than trying to remove it with Find and Replace.
Can I delete all objects on an Excel sheet at once?
Yes. Choose Home > Find & Select > Go To Special > Objects, select OK, and press Delete. This can also remove wanted charts, pictures, or other objects, so check the sheet first.
Why do the objects come back after I delete them?
They may be included again when you recopy data from the original source. Try Home > Paste > Paste Special and choose Text or Unicode Text if available, or download the data in another format such as CSV.
What if Excel will not let me delete an object?
Check Review > Unprotect Sheet to see whether sheet protection is preventing changes. You may need the owner's permission or password before you can remove the object.




