Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So, here's the situation:

  • I copy some data from a website into MS Excel.
  • I look at the data in MS Excel and see checkboxes.
  • When I select 'Design Mode' to delete the checkboxes, I see hidden textboxes.

I would like to select all the HTML or 'other' objects on the spreadsheet and delete them. Is there an easier way to do this than select one, hold down CTRL, and select the next one (repeat)?

I'm using MS Excel 2003.

Thanks! JFV

share|improve this question
up vote 3 down vote accepted

You can use Goto>Special>Objects to select all objects in the active sheet, then delete them in one go. This will remove all non-form HTML elements if data has been pasted in from a web page.

To wipe out any pasted form controls as well would need a bit of VBA to delete in one go:

Sub DeleteObjects()
    Dim obj As Object
    For Each obj In ActiveSheet.Shapes
End Sub
share|improve this answer
Rockin! That's an awesome tip! I was able to clear all the HTML Objects without breaking a sweat! Thanks! – JFV Sep 3 '09 at 15:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.