If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Delete 1 row of objects, not all on sheet Excel 2007
I know how to remove all objects on sheet, and 1 at a time. But I only want
to delete 1 row of objects on the worksheet, not all of them. There are many in the row, on top of each other. Thanks, Paula |
#2
|
|||
|
|||
Delete 1 row of objects, not all on sheet Excel 2007
What objects are they?
"Paula" wrote: I know how to remove all objects on sheet, and 1 at a time. But I only want to delete 1 row of objects on the worksheet, not all of them. There are many in the row, on top of each other. Thanks, Paula |
#3
|
|||
|
|||
Delete 1 row of objects, not all on sheet Excel 2007
Check boxes and group boxes.
"BSc Chem Eng Rick" wrote: What objects are they? "Paula" wrote: I know how to remove all objects on sheet, and 1 at a time. But I only want to delete 1 row of objects on the worksheet, not all of them. There are many in the row, on top of each other. Thanks, Paula |
#4
|
|||
|
|||
Delete 1 row of objects, not all on sheet Excel 2007
Perhaps this,
Home Tab, Find & Select, Selection Pane, CTRL + Left Click the objects to be removed, press Delete key. Paula wrote: Check boxes and group boxes. "BSc Chem Eng Rick" wrote: What objects are they? "Paula" wrote: I know how to remove all objects on sheet, and 1 at a time. But I only want to delete 1 row of objects on the worksheet, not all of them. There are many in the row, on top of each other. Thanks, Paula |
#5
|
|||
|
|||
Delete 1 row of objects, not all on sheet Excel 2007
Paula, Bob I's method should work. If these are ActiveX Controls it may not.
If this is the case, Developer -- Design Mode. Now you can blanket select the controls and delete them without activating them. If you done see the Developer Tab: Office Button -- Excel Options -- Popular -- Show Developer tab in the Ribbon. If this helps please click "Yes" "Bob I" wrote: Perhaps this, Home Tab, Find & Select, Selection Pane, CTRL + Left Click the objects to be removed, press Delete key. Paula wrote: Check boxes and group boxes. "BSc Chem Eng Rick" wrote: What objects are they? "Paula" wrote: I know how to remove all objects on sheet, and 1 at a time. But I only want to delete 1 row of objects on the worksheet, not all of them. There are many in the row, on top of each other. Thanks, Paula |
#6
|
|||
|
|||
Delete 1 row of objects, not all on sheet Excel 2007
I have lots of checkboxes layered on top of each other in the last rows of
each worksheet because I deleted columns. So, through the Selection Pane I have no fast way of finding all of the names of the boxes and group panes. It was not done in Activix. Is there something I am missing in your message or some other way to do this? Thanks! "Bob I" wrote: Perhaps this, Home Tab, Find & Select, Selection Pane, CTRL + Left Click the objects to be removed, press Delete key. Paula wrote: Check boxes and group boxes. "BSc Chem Eng Rick" wrote: What objects are they? "Paula" wrote: I know how to remove all objects on sheet, and 1 at a time. But I only want to delete 1 row of objects on the worksheet, not all of them. There are many in the row, on top of each other. Thanks, Paula |
#7
|
|||
|
|||
Delete 1 row of objects, not all on sheet Excel 2007
Instead of using the selection pane: Home Tab -- Editing -- Find & Select
-- Select Objects. Now you have an arrow instead of the Excel "plus". You can use the arrow to click and drag a blanket over the objects on the sheet without actually selecting cells. If this helps please click "Yes" "Paula" wrote: I have lots of checkboxes layered on top of each other in the last rows of each worksheet because I deleted columns. So, through the Selection Pane I have no fast way of finding all of the names of the boxes and group panes. It was not done in Activix. Is there something I am missing in your message or some other way to do this? Thanks! "Bob I" wrote: Perhaps this, Home Tab, Find & Select, Selection Pane, CTRL + Left Click the objects to be removed, press Delete key. Paula wrote: Check boxes and group boxes. "BSc Chem Eng Rick" wrote: What objects are they? "Paula" wrote: I know how to remove all objects on sheet, and 1 at a time. But I only want to delete 1 row of objects on the worksheet, not all of them. There are many in the row, on top of each other. Thanks, Paula |
#8
|
|||
|
|||
Delete 1 row of objects, not all on sheet Excel 2007
Ok, I found the blanket, rolled it over objects, but then could not delete or
cut them. What am I doing wrong? It is the first time I have used or seen the blanket. Thanks so far, Paula "BSc Chem Eng Rick" wrote: Instead of using the selection pane: Home Tab -- Editing -- Find & Select -- Select Objects. Now you have an arrow instead of the Excel "plus". You can use the arrow to click and drag a blanket over the objects on the sheet without actually selecting cells. If this helps please click "Yes" "Paula" wrote: I have lots of checkboxes layered on top of each other in the last rows of each worksheet because I deleted columns. So, through the Selection Pane I have no fast way of finding all of the names of the boxes and group panes. It was not done in Activix. Is there something I am missing in your message or some other way to do this? Thanks! "Bob I" wrote: Perhaps this, Home Tab, Find & Select, Selection Pane, CTRL + Left Click the objects to be removed, press Delete key. Paula wrote: Check boxes and group boxes. "BSc Chem Eng Rick" wrote: What objects are they? "Paula" wrote: I know how to remove all objects on sheet, and 1 at a time. But I only want to delete 1 row of objects on the worksheet, not all of them. There are many in the row, on top of each other. Thanks, Paula |
#9
|
|||
|
|||
Delete 1 row of objects, not all on sheet Excel 2007
I've recreated your problem and it turns out that for some reason the blanket
select does not work on form controls (yet another ms glitch-we-can-live-with). The only way I could delete them was to use the "Select Objects" as below but without the blanket. I clicked one of the checkboxes and then pressed delete on the keyboard. This is not really that tedious if they are all close together. Note: that by using select objects you don't activate the control but rather select it (it gets a dotted border with object handles), now you can delete as normal. If this helps please click "Yes" "Paula" wrote: Ok, I found the blanket, rolled it over objects, but then could not delete or cut them. What am I doing wrong? It is the first time I have used or seen the blanket. Thanks so far, Paula "BSc Chem Eng Rick" wrote: Instead of using the selection pane: Home Tab -- Editing -- Find & Select -- Select Objects. Now you have an arrow instead of the Excel "plus". You can use the arrow to click and drag a blanket over the objects on the sheet without actually selecting cells. If this helps please click "Yes" "Paula" wrote: I have lots of checkboxes layered on top of each other in the last rows of each worksheet because I deleted columns. So, through the Selection Pane I have no fast way of finding all of the names of the boxes and group panes. It was not done in Activix. Is there something I am missing in your message or some other way to do this? Thanks! "Bob I" wrote: Perhaps this, Home Tab, Find & Select, Selection Pane, CTRL + Left Click the objects to be removed, press Delete key. Paula wrote: Check boxes and group boxes. "BSc Chem Eng Rick" wrote: What objects are they? "Paula" wrote: I know how to remove all objects on sheet, and 1 at a time. But I only want to delete 1 row of objects on the worksheet, not all of them. There are many in the row, on top of each other. Thanks, Paula |
#10
|
|||
|
|||
Delete 1 row of objects, not all on sheet Excel 2007
I'm afraid you have made quite a mess of the Check boxes, when you click
on the name in the Selection pane it will select the object in the Window for you. You will need to determine what get deleted. There is no "automatic fix" Paula wrote: I have lots of checkboxes layered on top of each other in the last rows of each worksheet because I deleted columns. So, through the Selection Pane I have no fast way of finding all of the names of the boxes and group panes. It was not done in Activix. Is there something I am missing in your message or some other way to do this? Thanks! "Bob I" wrote: Perhaps this, Home Tab, Find & Select, Selection Pane, CTRL + Left Click the objects to be removed, press Delete key. Paula wrote: Check boxes and group boxes. "BSc Chem Eng Rick" wrote: What objects are they? "Paula" wrote: I know how to remove all objects on sheet, and 1 at a time. But I only want to delete 1 row of objects on the worksheet, not all of them. There are many in the row, on top of each other. Thanks, Paula |
|
Thread Tools | |
Display Modes | |
|
|