Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Check Boxes | Excel Worksheet Functions | |||
count check boxes | Excel Worksheet Functions | |||
Protection of check boxes in excel 2002 | Excel Discussion (Misc queries) | |||
How to align check boxes on an Excel sheet? | Excel Worksheet Functions | |||
Adding Check Boxes | Excel Discussion (Misc queries) |