Duplicate worksheet
Master this Excel shortcut with our comprehensive guide
Drag (Mouse) Shortcuts
Ctrl + Drag
⌘ + Drag
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Drag
Instructions
1. Right-click the worksheet tab you want to copy
2. Hold Ctrl
3. Drag the tab to a new location
4. Release the mouse button to create a duplicate sheet
2. Hold Ctrl
3. Drag the tab to a new location
4. Release the mouse button to create a duplicate sheet
Keyboard Shortcut
⌘ + Drag
Instructions
1. Control-click the worksheet tab
2. Hold Command
3. Drag to a new position
4. Release to duplicate the sheet
2. Hold Command
3. Drag to a new position
4. Release to duplicate the sheet
💡 Pro Tip: Use to quickly make a backup of a worksheet before making large changes.
Quick Actions
More Drag (Mouse) Shortcuts
Ctrl + Drag
Shift + Drag