Deleting Text Boxes

P

Paul N

I have inherited a spreadsheet which for some strange reason has literally
thousands of small text boxes scattered throughout the sheets. I know how to
delete one at a time but I was wondering if there was a way to SELECT ALL
text boxes in a sheet and hit delete once.

Any ideas?
 
P

Peo Sjoblom

Press F5, select Special then Objects and hit delete, beware that it will
select all objects not only text boxes

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 
Top