Drag and drop · original practice scenario
Duplicate a worksheet by dragging its tab
A worksheet named Weekly plan is ready to reuse.
Start here: Worksheet tab bar in a workbook with permission to change its sheet structure
The copy includes the sheet contents and formulas; review references before using it as a new reporting period.
Follow these instructions in your own desktop Excel workbook. This page explains the operation; it does not send commands to Excel.
Mac keys and context
Hold Ctrl on Windows or Option (Alt) on Mac while dragging a sheet tab. This acts on a worksheet, not a selected cell range.
Alt+Drag
Copy a worksheet in the same workbook. Microsoft reference ↗
Walk through the operation
- Point at the Weekly plan sheet tab.
- Hold the platform modifier and drag the tab to a new position.
- Release the mouse, then the modifier.
Instruction 1 of 3: Point at the Weekly plan sheet tab.
Expected result: A copied worksheet appears alongside the original.
Recall the keys
Which listed Mac combination or sequence starts this operation in the context above?
Related walkthroughs
- Copy a cell range by dragging its border
- Insert a copy of selected rows by dragging
- Move a selected block to another worksheet
Catalog updated 2026-10-18. US keyboard notation: + joins held keys; commas separate successive presses. Function keys may require Fn. Desktop instructions are separate from this browser's own keyboard shortcuts.