Duplicate Object in Excel (Ctrl + Drag)
Duplicating objects like shapes, charts, or images in Excel is easy with the Ctrl + Drag shortcut. This allows you to copy objects without using Copy-Paste.
Keyboard Shortcut
| Windows / Mac |
|---|
| Hold Ctrl while dragging the object |
What Does This Shortcut Do?
Holding Ctrl while dragging an object creates an exact copy of the selected object in a new location. The original object remains in place.
How to Use the Shortcut
- Select the object you want to duplicate
- Hold down the Ctrl key
- Click and drag the object to a new location
- Release the mouse button first, then release Ctrl to create the duplicate
Tips & Best Practices
- Use this method to quickly create multiple copies of shapes or charts
- Combine with alignment guides to position duplicates precisely
- Works for multiple selected objects at once
- Can be used on charts, images, shapes, and text boxes
FAQ
- Q: Can I duplicate multiple objects at once?
- Yes, select multiple objects and hold Ctrl while dragging to duplicate all selected objects.
- Q: Does this shortcut work on Mac?
- Yes, the same method applies using the Command key instead of Ctrl on Mac if needed.
- Q: Can I undo the duplication?
- Yes, press Ctrl + Z (Windows) or Cmd + Z (Mac) immediately after duplicating.