Excel Tips: How to Quickly Duplicate a Sheet

Lesson 6: How to Quickly Duplicate a Sheet


How to quickly duplicate a sheet

When creating a new worksheet, you may not always want to start from a blank sheet. It's often better to duplicate an existing sheet instead, and there's a quick shortcut that can help with this. Simply hold down the Ctrl key, then click and drag the sheet's tab. When you release the mouse, Excel will create an exact copy of the sheet.

Watch the video below to see this shortcut in action.