Multiple Taxt Boxes - Excel 2007

D

Daisy

I have been working with a rather large workbook which includes various, but
simple formulas.

Recently I noticed that a couple of the worksheets were very very slow to
work with moving cell to cell and up and down the page.

I also noticed that there seems to be numerous empty and very tiny text
boxes. I am not using text boxes in my application. I think this is the
problem with these pages.

How/can I locate all text boxes and delete them?

Daisy
 
D

Dave Peterson

Do you have any objects that should be saved on that sheet?

If no, then
Hit F5|Click special|select objects|click ok|and hit the delete key on the
keyboard.
 

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

Text boxes move on protected worksheet 3
Tabbing between text boxes in Excel 2007 1
Excel spreadsheet is corrupted with multiple text boxes? 1
link check boxes in multiple cells 1
Help! I can't see the text in my non-empty cells. 8
delete caption on multiple check boxes 2
How to Import Visio Text Boxes into Excel as Text 2
Changing color in text boxes based on content 1

Top