Document Editing Problems

Remove Unwanted Objects and Boxes from Excel Worksheets

Steve KSteve K Nov 22, 2026 868 views

Question details

The user wants to remove unwanted boxes and objects copied into an Excel worksheet and prevent them from being added again.

Remove Unwanted Objects and Boxes from Excel Worksheets
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.
Before you start

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.

Solution 1Recommended

Remove unwanted objects with the Selection Pane

Use the Selection Pane to identify and delete individual objects without removing every object on the sheet.

1
Open the Selection Pane

In Excel, open the affected worksheet and choose Home > Find & Select > Selection Pane.

2
Identify the objects

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.

3
Delete unwanted items

Select an unwanted object in the pane or click its border on the sheet, then press Delete. Repeat for other unwanted objects.

Remove unwanted objects with the Selection Pane
If an object cannot be deleted: Check whether the worksheet is protected under Review > Unprotect Sheet. You may need permission or a password to change it.
Work with spreadsheets in WPS Office

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. 1. Open the workbook: In WPS Spreadsheet, choose Open and select the Excel workbook containing the unwanted boxes.
  2. 2. Select a box: Click the edge of an unwanted box until its resize handles appear.
  3. 3. Delete the object: Press Delete, then repeat for any other unwanted boxes.
  4. 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.
Remove unwanted boxes by selecting their bordersOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfacePaste copied data as text when the option is available
microsoft office alternative - wps office

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.