Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Objects all at once - (copied HTML to excel) | Excel Discussion (Misc queries) | |||
Excel 2002 : Any faster way for linking formulas between pages ? | Excel Discussion (Misc queries) | |||
Deleting HTML form objects? | Excel Discussion (Misc queries) | |||
Excel 2002 auto deleting | Excel Discussion (Misc queries) | |||
Deleting Objects Copied from Web Page | Excel Discussion (Misc queries) |