View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Deleting HTML form objects?

See if this "quick fix" works

Select a single cell...then
Press the [F5] key........that's the shortcut for <edit<go to
Click the [Special] button
Select: Objects
Click the [OK] button
(all of the objects should now be selected)

Next...just press the [Delete] key

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"GeorgeM" wrote:

I frequently need to copy and paste a page from one of our website's
admin screens into a spreadsheet. The HTML page includes HTML forms,
like check boxes and drop-down lists.

I can't figure out how to get rid of these HTML form elements.
Deleting the column they appear to be in just moves them into the
adjacent column on the right. Deleting the single cell the object
appears to be in has unpredictable results - sometimes it works,
sometimes it doesn't.

I'm pasting as HTML, because the table in HTML drops so nicely into
cells. If I paste as Text, each row is a useless unformatted string.

Any solutions?

Thanks

George