How do you select multiple checkboxes in Excel 2007?

[stuckagain22]

I have found this very frustrating in Excel 2007!

I have 200+ form checkboxes that I want to select all at once.

With pre-Excel 2007 versions, I would just select the arrow pointer from the Drawing toolbar and that would allow me to drag & drop a selection square around the desired control boxes.

I have spent hours trying to find a similar feature in Excel 2007, but I just can't find it.

Please help.

 

[kgartin]

The original question was for all checkboxes to be selected.

You are asking for only some.

There is no "arrow" with the functionality you decribe.

It would be easier if you stick to one thread.

 

[krank]

I know this is an old post but it came up on my Google search so for those who still might be using this:

In the "Find and Select" menu on the Home tab, click the selection pane option. Click on a checkbox name inside the selection pane, and then hit Ctrl-A to select all of them.

 

[Josiah]

NO NO NO NO NO NO NO NO NO NO NO!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Listen folks...I have a sheet with about 200 check boxes in it. I want to delete about 75% of these check boxes (I want some to remain). If I use the SELECTION PANE and click ALL, then there are some check boxes selected that I do not WANT to delete. Yes, I understand that I can manually deselect them (individually) but how STUPID and TIME CONSUMING is that?! There HAS to be a way for me to just drag over top of the ones I want to delete on the sheet itself to select them and delete them!

This is the most ludicrous thing I've ever seen in my life.

 

[kamifish]

Arrow pointer:

Home tab, far right, click Find & Select, and the Select Objects button is
near the bottom.

Keep aspect ratio (angle of a line) constant while changing its size:

Hold the Shift key, just like in pre-2007 versions.

 

[Xclent]

Arrow pointer:

Home tab, far right, click Find & Select, and the Select Objects button is
near the bottom.

Keep aspect ratio (angle of a line) constant while changing its size:

Hold the Shift key, just like in pre-2007 versions.

SUPERBBBBBB!!!!