Mutiple Check boxes flashing on sheet

D

danc

I have produced a spreadsheet that contains hundreds of checkboxes.
I copied and pasted them as I needed them from the original check boxe
I started with.
It appears that they have multiplied themselves on top of each othe
and I cannot just delete them without having to do it to each on
individually which will take me forever.

Any help out there before I lose it?

Thank
 
B

Biff

Hi!

One way if the ckbxs are the only objects you have on the sheet:

Hit function key F5
Special>Objects
OK
Edit>Clear>All

Biff
 
B

Biff

The F5 key on Excel 200 is for "Go To".
Not sure what you meant.
Click to expand...

Yes, F5 is "Go To". Checkboxes are called objects, so you want to "Go To"
(select) all objects.

Hit function key F5
Click the Special button on the lower left hand side
From the list that's presented select Objects
Click OK

Now, all the objects (checkboxes) will be selected.

To delete them:

Goto Edit>Clear>All

Biff
 
Top