How to Remove Small Boxes Copied into Excel
Question details
The user needs to delete unwanted small boxes or checkboxes that appear after pasting data from a web source.

- 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.
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.
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.
Press the F5 key on your keyboard, or press Ctrl+G, to open the 'Go To' dialog box.
Click the 'Special...' button located at the bottom left of the 'Go To' window.
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.
Press the Delete key on your keyboard to instantly remove all the selected objects.

Remove Individual Shapes Manually
Best for spreadsheets where you only have a few unwanted boxes or if you need to keep certain shapes while deleting others.
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. Open your file in WPS: Launch WPS Spreadsheet and open the document containing the pasted web data.
- 2. Use the Go To tool: Press Ctrl+G on your keyboard to launch the Go To dialog box.
- 3. Select and delete objects: Click 'Special', select 'Objects', hit 'OK', and then press the Delete key to clear all unwanted boxes.

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.




