bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Graphics > Quickly Duplicating Drawing Objects

Quickly Duplicating Drawing Objects

Summary: Excel provides a couple of different ways that you can quickly duplicate drawing objects in a worksheet. Committing these shortcuts to memory will help make your work with drawing objects easier than ever. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

You probably know that you can copy drawing objects using the familiar copy (Ctrl+C) and paste (Ctrl+V) commands. You may not know that there are other ways--quicker ways--that you can accomplish the same task.

The first method simply entails selecting the object and pressing Ctrl+D. That's it; the object is duplicated. In addition, if you hold down the shortcut key for a few seconds, the "autorepeat" feature of your keyboard will kick in and you can duplicate the object a zillion times in short order. Once duplicated, you can move the new objects where ever you need them in your worksheet.

If you prefer to use the mouse, you can duplicate objects by holding down the Ctrl key as you click an drag the object you want to duplicate. When you release the mouse button, the object is duplicated at the point where you released the button.

Another benefit of both of these approaches is that you don't need to use the Clipboard. That means you won't disturb anything you previously copied to the Clipboard. These techniques work equally well for ClipArt, WordArt, and AutoShapes, as well as text boxes.

Tip #2481 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007


Save Time! You can have this tip (and several hundred just like it) in the ExcelTips annual archives. Imagine having over 400 tips available at your fingertips, in each annual volume.

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)