Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove check box that came with web page copy?
When I copy a web page with a table that contains check boxes into
Excel, the check boxes gets copied into the work sheet and I can't figure out how to remove them! The check box just sits there and won't be deleted, even if I delete the cell that surrounds it. The same thing sometimes happens with small icons, and I suppose it is the same mechanism in Excel in that case. Can anyone please enlighten me as how this works, so I can remove the unwanted check boxes? Per. PS. Copying as text is not a solution, I need the data to be inserted into columns. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove check box that came with web page copy?
(xl2003 menu system)
Show the Control toolbox toolbar (view|toolbars) Click on the Design mode icon Select the checkbox you want to delete and hit the delete key on the keyboard. if you want to delete all the objects on the worksheet, you can: Edit|Goto|special|objects and hit the delete key on the keyboard. Don't use this if there are other objects you want to keep, though. perstromgren wrote: When I copy a web page with a table that contains check boxes into Excel, the check boxes gets copied into the work sheet and I can't figure out how to remove them! The check box just sits there and won't be deleted, even if I delete the cell that surrounds it. The same thing sometimes happens with small icons, and I suppose it is the same mechanism in Excel in that case. Can anyone please enlighten me as how this works, so I can remove the unwanted check boxes? Per. PS. Copying as text is not a solution, I need the data to be inserted into columns. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove check box that came with web page copy?
On 23 Nov, 16:59, Dave Peterson wrote:
(xl2003 menu system) Show the Control toolbox toolbar (view|toolbars) Click on the Design mode icon Select the checkbox you want to delete and hit the delete key on the keyboard. Thanks, that worked fine! I did not know anything about the Contol Tool Box. Dave Peterson Per. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove big gray page number on Page Break Preview??? | Excel Discussion (Misc queries) | |||
How do I remove the big page number on the Page Break Preview | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
How do I remove the page number from a page break preview and kee. | Excel Discussion (Misc queries) | |||
How can I remove a large page number from each page in Excel | Excel Discussion (Misc queries) |