Check boxes in a column

[Guest]

I keep copying and pasting into a master docuement. However whenever I take
information from a web page and post it into the Excel master sheet, I am
getting these check boxes in the next column.

I have tried clearing the contents but the boxes stay in the column
I have tried deleting that column but the boxes stay

Any ideas to get rid of this column of checkboxes without disrupting my data
in the other column?

 

[Dave Peterson]

You can show the Drawing toolbar and then use the Arrow icon to lasso the
checkboxes that you want do delete.

In fact, if you want to get rid of all the objects on the worksheet, you can
hit:
edit|goto|special|click the objects radio button

After they're all selected, just hit the delete key on the keyboard.

 

[Guest]

Well using the Special > Obects method took out SOME of the boxes
but most of them still are showing up in Column B. I can even "check" them.

Lasso'ing didnt work.

Any other ideas?

 

[Dave Peterson]

Can you right click on them?

And if you do, can you see the outline of the checkbox?

If you can't, then try showing the Control toolbox toolbar and clicking on the
Design mode icon.

Then try the F5 (or lassoing them again).

 

[Guest]

BINGO!!!!
Control Toolbox > Lasso > Delete!!!!

You DA MAN!!!!
MANY THANKS!!!

 

[Dave Peterson]

Woohoo!!

BINGO!!!!
Control Toolbox > Lasso > Delete!!!!

You DA MAN!!!!
MANY THANKS!!!