View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Unable to remove objects pasted into Excel from HTML grid

Try this:

Press the [F5] key (shortcut to <edit<goto)
Clcik the [special...] button
Check: objects
Click the [OK] button

That should select ALL objects on the worksheet.
Press the [Delete] key to remove them

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

XL2002, WinXP


"kydan47" wrote:

Copied & pasted an html page into Excel. Has little check boxes that will can
be checked, but not removed. Can't grab them, deleting columns or rows just
moves them over by one.

Any idea how to get rid of them? Would like to keep the rest of the data.
Have tried using every command or option found, must be missing something.

Thanks in advance,
--
Thanks!
kydan47