Formatting Issues

How to Remove Small Boxes Copied into Excel

Kushani NimanthikaKushani Nimanthika Oct 14, 2026 870 views

Question details

The user needs to delete unwanted small boxes or checkboxes that appear after pasting data from a web source.

How to Remove Small Boxes Copied into Excel
Product
Excel
Device & OS
not provided
Scenario
Copying and pasting bank transactions or other structured data from a webpage into an Excel spreadsheet.
Observed behavior
Small boxes, which are actually floating shapes or checkboxes from the source webpage, appear over the cells alongside the pasted text.
Before you start

Verify whether the small boxes are floating objects (you can click and drag them) or unprintable text characters located inside the cell itself, as the removal methods differ.

Solution 1Recommended

Delete All Objects at Once Using Go To Special

This is the most efficient method to remove all copied checkboxes and shapes simultaneously without deleting your data.

When copying from the web, HTML elements often convert into Excel objects. The 'Go To Special' feature allows you to select all these floating objects in the active worksheet at once, saving you from clicking them one by one.

1
Open the Go To dialog

Press the F5 key on your keyboard, or press Ctrl+G, to open the 'Go To' dialog box.

2
Access Special settings

Click the 'Special...' button located at the bottom left of the 'Go To' window.

3
Select Objects

In the 'Go To Special' menu, select the radio button next to 'Objects' and click 'OK'. This will highlight every shape, image, and checkbox in your sheet.

4
Delete the boxes

Press the Delete key on your keyboard to instantly remove all the selected objects.

Delete All Objects at Once Using Go To Special
Preventing the issue: To prevent these boxes from appearing in the first place, use 'Paste Special' > 'Text' when pasting web data into your spreadsheet.
Effortless Data Cleanup

Quickly Clean Up Web Data with WPS Spreadsheet

WPS Spreadsheet offers a seamless and highly compatible environment for managing imported data. Its powerful selection tools make it incredibly easy to isolate and delete unwanted web objects like checkboxes and shapes in seconds.

  1. 1. Open your file in WPS: Launch WPS Spreadsheet and open the document containing the pasted web data.
  2. 2. Use the Go To tool: Press Ctrl+G on your keyboard to launch the Go To dialog box.
  3. 3. Select and delete objects: Click 'Special', select 'Objects', hit 'OK', and then press the Delete key to clear all unwanted boxes.
Easily bulk-select and delete unwanted HTML objects and shapes pasted from web browsers.Fully compatible with Microsoft Excel (.xlsx, .xls) formats for a seamless transition.Provides intuitive 'Paste Special' options to paste unformatted text directly, avoiding messy data.Lightweight, fast, and free to use for everyday office tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Why do small boxes appear when I copy bank transactions into Excel?

Bank websites often use HTML elements for styling, such as checkboxes, buttons, or CSS graphics. When you copy data directly from the webpage, Excel attempts to preserve this layout and pastes those elements as floating graphical objects over your cells.

How can I copy web data without bringing over the boxes?

Instead of using the standard paste (Ctrl+V), right-click the destination cell in Excel, select 'Paste Special', and choose 'Text' or 'Unicode Text'. This pastes only the raw text, leaving behind all web formatting, links, and floating objects.

What if the small boxes are inside the text string and not selectable shapes?

If the boxes cannot be clicked individually and appear as characters inside the text (often representing unprintable characters), you can remove them using the CLEAN function in a neighboring column (e.g., =CLEAN(A1)), or by copying the box character and using the Find and Replace tool (Ctrl+H) to replace it with nothing.

Will deleting all objects using 'Go To Special' delete my charts?

Yes, 'Go To Special' > 'Objects' selects all graphical elements on the worksheet, including charts, images, and text boxes. If you have charts or images you want to keep, you should use the Selection Pane (Page Layout > Selection Pane) to hide them first, or manually select the unwanted boxes.