Exceljet

Quick, clean, and to the point

Drag to worksheet

Windows shortcut 
Altdrag
Mac shortcut 
drag

Normally drag and drop only works in the same worksheet. If you want to drag a selection to a different worksheet, use this shortcut.

Related videos

The videos below demonstrate this shortcut.
In this video, we'll look at how to apply number formats to a chart using special codes.
In this video, we'll look at how to update data in a pivot chart. Like pivot tables, pivot charts require a refresh.
In this video, we'll look at how to add a secondary axis to chart. A secondary axis allows you to data with a different scale in the same chart.
Excel charts can exist in as an embedded object, floating above the cell grid, or, in a sheet all by themselves. In this video, we'll look at how to move charts from one state to the other.
In this video, we'll look at how to make an area chart. Like line charts, area charts are a good way to show trends over time.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.