Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BenJAMMIN
 
Posts: n/a
Default Check boxes in a column

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?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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.

BenJAMMIN wrote:

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
  #3   Report Post  
BenJAMMIN
 
Posts: n/a
Default

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" wrote:

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.

BenJAMMIN wrote:

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

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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).



BenJAMMIN wrote:

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" wrote:

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.

BenJAMMIN wrote:

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


--

Dave Peterson
  #5   Report Post  
BenJAMMIN
 
Posts: n/a
Default

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

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

"Dave Peterson" wrote:

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).



BenJAMMIN wrote:

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" wrote:

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.

BenJAMMIN wrote:

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


--

Dave Peterson



  #6   Report Post  
Dave Peterson
 
Posts: n/a
Default

Woohoo!!

BenJAMMIN wrote:

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

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

"Dave Peterson" wrote:

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).



BenJAMMIN wrote:

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" wrote:

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.

BenJAMMIN wrote:

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


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Check Boxes Tony Excel Worksheet Functions 4 April 12th 05 05:58 PM
count check boxes Tony Excel Worksheet Functions 3 April 8th 05 03:48 AM
Protection of check boxes in excel 2002 Newbeetle Excel Discussion (Misc queries) 2 March 14th 05 12:59 PM
How to align check boxes on an Excel sheet? CC Excel Worksheet Functions 2 February 16th 05 03:27 PM
Adding Check Boxes Mike R Excel Discussion (Misc queries) 2 February 13th 05 03:59 AM


All times are GMT +1. The time now is 01:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"