Delete 1 row of objects, not all on sheet Excel 2007

[Paula]

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

 

[BSc Chem Eng Rick]

What objects are they?

 

[Paula]

Check boxes and group boxes.

What objects are they?

 

[Bob I]

Perhaps this,

Home Tab, Find & Select, Selection Pane, CTRL + Left Click the objects
to be removed, press Delete key.

 

[BSc Chem Eng Rick]

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

 

[Paula]

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!

 

[BSc Chem Eng Rick]

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]

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]

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

 

[Bob I]

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]

Thanks to both of you. I did not get a quick fix for that, but I learned a
lot trying.

 

[Bob I]

You're welcome, at least now you may choose what to delete fairly quickly.