Deleting Text Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedding check boxes into Excel cells 0
Delete rows in a workbook that contain the same information 2
check box question 3
How do I deselect a row in Excel when selecting w/ the ctrl key? 1
Link text box to a cell 1
Removing a picture box from an Excel 2007 spreadsheet 5
Need to remove text with strikethrough - Excel 2007 6
Protecting Sheets with drop down boxes 1

Back
Top