Exceljet

Quick, clean, and to the point

Drag and copy

Windows shortcut

Ctrldrag

Mac shortcut

⌥drag

The default behavior for drag and drop is to cut data in cells, but you can also copy cells during drag and drop. To copy cells, use this shortcut before or after you start to drag the selection. Excel will display a small plus (+) symbol to indicate the copy operation.

222 Excel Shortcuts for Windows and Mac

Comments welcome! Read this before posting a question.

Thank you for your clear explanation on the sumifs function. It was exactly what I needed to simplify a massive spreadsheet where I need to summarize a range of amounts from over 70 sheets in a workbook. The previous person would manually update the formulas each year but now the "sumifs between dates" formula will automate this. Huge Thanks!! -Sarah

Drag and copy

Download 200+ Excel Shortcuts

Excel video training