
Tips.Net > ExcelTips Home > Graphics > 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.
Have thousands of ExcelTips at your fingertips, on your own system. Answer your own questions or help support others. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
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