Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |