Excel 2002: Any faster way of deleting floating objects?
 

Hi,

I have a worksheet with 10 floating objects generated from Print Screen
Paste.

At present, I would place the cursor on the object and press "Delete" to
cleat it one by one.

I find this process is slow. May I kknow if there is a faster way of doing
this ?

Thanks

Low

--
A36B58K641

Excel 2002: Any faster way of deleting floating objects?
 

If you click on the Select Objects arrow, in the drawing toolbar and then
describe a selection box, it will select everything inside. Alternatively,
if you hold down SHIFT and click on each object, you can select multiple
objectives for deletion.
--
<a href="http://www.kan.org/tips"Tips for Excel, Word, PowerPoint and Other
Applications</a


"Mr. Low" wrote:

Hi,

I have a worksheet with 10 floating objects generated from Print Screen
Paste.

At present, I would place the cursor on the object and press "Delete" to
cleat it one by one.

I find this process is slow. May I kknow if there is a faster way of doing
this ?

Thanks

Low

--
A36B58K641

Excel 2002: Any faster way of deleting floating objects?
 

Although shift-click can extend the selection, I think I'd recommend ctrl-click.



M Kan wrote:

If you click on the Select Objects arrow, in the drawing toolbar and then
describe a selection box, it will select everything inside. Alternatively,
if you hold down SHIFT and click on each object, you can select multiple
objectives for deletion.
--
<a href="http://www.kan.org/tips"Tips for Excel, Word, PowerPoint and Other
Applications</a

"Mr. Low" wrote:

Hi,

I have a worksheet with 10 floating objects generated from Print Screen
Paste.

At present, I would place the cursor on the object and press "Delete" to
cleat it one by one.

I find this process is slow. May I kknow if there is a faster way of doing
this ?

Thanks

Low

--
A36B58K641

--

Dave Peterson

Excel 2002: Any faster way of deleting floating objects?
 

F5SpecialObjectsOKDelete


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 06:25:01 -0700, Mr. Low
wrote:

Hi,

I have a worksheet with 10 floating objects generated from Print Screen
Paste.

At present, I would place the cursor on the object and press "Delete" to
cleat it one by one.

I find this process is slow. May I kknow if there is a faster way of doing
this ?

Thanks

Low

Excel 2002: Any faster way of deleting floating objects?
 

Hi Gord,

Thnaks for your help.

In fact you got the fastest way of doing the task.

Best Regards.

Low

--
A36B58K641


"Gord Dibben" wrote:

F5SpecialObjectsOKDelete


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 06:25:01 -0700, Mr. Low
wrote:

Hi,

I have a worksheet with 10 floating objects generated from Print Screen
Paste.

At present, I would place the cursor on the object and press "Delete" to
cleat it one by one.

I find this process is slow. May I kknow if there is a faster way of doing
this ?

Thanks

Low

Excel 2002: Any faster way of deleting floating objects?
 

Hi M Kan,

Thanks for your tip.

Low

--
A36B58K641


"M Kan" wrote:

If you click on the Select Objects arrow, in the drawing toolbar and then
describe a selection box, it will select everything inside. Alternatively,
if you hold down SHIFT and click on each object, you can select multiple
objectives for deletion.
--
<a href="http://www.kan.org/tips"Tips for Excel, Word, PowerPoint and Other
Applications</a


"Mr. Low" wrote:

Hi,

I have a worksheet with 10 floating objects generated from Print Screen
Paste.

At present, I would place the cursor on the object and press "Delete" to
cleat it one by one.

I find this process is slow. May I kknow if there is a faster way of doing
this ?

Thanks

Low

--
A36B58K641

Excel 2002: Any faster way of deleting floating objects?
 

Hi Dave,

Thanks for the tips.

Cntr + Click is a better way as it enable negative zooming for faster
selecttion of the floating objects.

Best Regards

Low




--

A36B58K641


"Dave Peterson" wrote:

Although shift-click can extend the selection, I think I'd recommend ctrl-click.



M Kan wrote:

If you click on the Select Objects arrow, in the drawing toolbar and then
describe a selection box, it will select everything inside. Alternatively,
if you hold down SHIFT and click on each object, you can select multiple
objectives for deletion.
--
<a href="http://www.kan.org/tips"Tips for Excel, Word, PowerPoint and Other
Applications</a

"Mr. Low" wrote:

Hi,

I have a worksheet with 10 floating objects generated from Print Screen
Paste.

At present, I would place the cursor on the object and press "Delete" to
cleat it one by one.

I find this process is slow. May I kknow if there is a faster way of doing
this ?

Thanks

Low

--
A36B58K641

--

Dave Peterson

Excel 2002: Any faster way of deleting floating objects?
 

Thanks, but only if you want to delete ALL objects.


Gord

On Fri, 18 Jul 2008 08:10:00 -0700, Mr. Low
wrote:

Hi Gord,

Thnaks for your help.

In fact you got the fastest way of doing the task.

Best Regards.

Low