Prev: How to lock Track Changes
Next: I created a custom template but the background will not print?
From: Daisy on 22 Apr 2010 11:32
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
From: Bob I on 22 Apr 2010 11:35
Find and Select, Selection Pane.

Daisy wrote:

> 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

From: Dave Peterson on 22 Apr 2010 13:29
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.

Daisy wrote:
>
> 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

--

Dave Peterson
 | 
Pages: 1
Prev: How to lock Track Changes
Next: I created a custom template but the background will not print?