software

For unknown reason, I had more than 7000 blank text boxes embedded in my
spreadsheet. Seemed like one on top of the other. This blew up my file to
about 1.44Mb and considerably slowing down the performance. Is there a way to
delete those text boxes really quick?

Thanks in advance.

Evan

Hit F5, click on Special, select Objects, click OK, hit delete.
Beware - ALL objects will be deleted, so if you've got some that you
want to keep, hold down Ctrl and deselect the loved ones.
Rgds,
ScottO

quot;EKquot; gt; wrote in message
...
| For unknown reason, I had more than 7000 blank text boxes embedded
in my
| spreadsheet. Seemed like one on top of the other. This blew up my
file to
| about 1.44Mb and considerably slowing down the performance. Is
there a way to
| delete those text boxes really quick?
|
| Thanks in advance.
|
| Evan
Thank you it worked. Do you by any chance know what could have caused it so
that I won't repeat the same error?

Thanks,
Evan

quot;ScottOquot; wrote:

gt; Hit F5, click on Special, select Objects, click OK, hit delete.
gt; Beware - ALL objects will be deleted, so if you've got some that you
gt; want to keep, hold down Ctrl and deselect the loved ones.
gt; Rgds,
gt; ScottO
gt;
gt; quot;EKquot; gt; wrote in message
gt; ...
gt; | For unknown reason, I had more than 7000 blank text boxes embedded
gt; in my
gt; | spreadsheet. Seemed like one on top of the other. This blew up my
gt; file to
gt; | about 1.44Mb and considerably slowing down the performance. Is
gt; there a way to
gt; | delete those text boxes really quick?
gt; |
gt; | Thanks in advance.
gt; |
gt; | Evan
gt;
gt;
gt;

One way I can (sort of) re-create it ...
If you copy and paste a text box, and then *accidentally* hold down
the F4 key, you get multiple 'pastes'.
Maybe you did something like that ...
Rgds,
ScottO

quot;EKquot; gt; wrote in message
...
| Thank you it worked. Do you by any chance know what could have
caused it so
| that I won't repeat the same error?
|
| Thanks,
| Evan
|
| quot;ScottOquot; wrote:
|
| gt; Hit F5, click on Special, select Objects, click OK, hit delete.
| gt; Beware - ALL objects will be deleted, so if you've got some that
you
| gt; want to keep, hold down Ctrl and deselect the loved ones.
| gt; Rgds,
| gt; ScottO
| gt;
| gt; quot;EKquot; gt; wrote in message
| gt; ...
| gt; | For unknown reason, I had more than 7000 blank text boxes
embedded
| gt; in my
| gt; | spreadsheet. Seemed like one on top of the other. This blew up
my
| gt; file to
| gt; | about 1.44Mb and considerably slowing down the performance. Is
| gt; there a way to
| gt; | delete those text boxes really quick?
| gt; |
| gt; | Thanks in advance.
| gt; |
| gt; | Evan
| gt;
| gt;
| gt;