Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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
        obj.Delete
    Next
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

 
discard

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.