Select buttons pasted into Excel

  • Thread starter Thread starter jzemanek
  • Start date Start date
J

jzemanek

I pasted a table from my investment account into Excel. The tabl
included option buttons. I can get rid of the alpha/numeric part of th
paste but the buttons remain.
I've tried to format & copy empty cells but the button remains. I ca
turn on the button -- nothing happens that I am aware of.

How do I get rid of it?? Delete or clear doesn't work.
joe
 
If they are objects you can right click on it and then delete it.
If you have a lot of them you can click on Edit>Go To>Special>Object
and this will select ALL objects on your sheet. If the only object
you have are the ones you want to get rid of then you can just hit th
delete key while they are all selected. If you have ones you want t
keep then hold down the shift key and click on those to deselect them
 
Back
Top