Drag and drop · original practice scenario
Move a selected block to another worksheet
In a disposable workbook, put Code and Quantity in A1:B1 and M7 and 4 in A2:B2 on Draft. Add a second empty sheet named Archive.
Start here: Cell selection border, outside edit mode, with an empty destination worksheet
Use a spare workbook and empty destination. A drag can move or overwrite cells; undo immediately if the destination is wrong. This is a held mouse gesture, not a key sequence.
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
Cmd+drag
Publisher-documented binding. Native desktop execution has not been tested.
Desktop key table and operation notes; reviewed 2026-10-18. Exceljet publisher reference ↗
Walk through the operation
- Select Draft!A1:B2 and point at its selection border rather than the fill handle.
- Hold the listed modifier while dragging the selection over the Archive tab, then into an empty destination range.
- Release at the destination and inspect both sheets before continuing.
Instruction 1 of 3: Select Draft!A1:B2 and point at its selection border rather than the fill handle.
Expected result: The selected block is moved to Archive; verify the destination values and the vacated source range.
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
- Duplicate a worksheet by dragging its tab
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.