Drag Data Between Excel Worksheets

Have you ever tried to drag and drop data from one worksheet to another in MS Excel?

What happened?

I just bet that you started dragging that information towards the sheet tabs (looking to switch between worksheets) and were stunned to find that all the worksheet wanted to do was zoom off to some extremely high row number.

Now what?

Many people use Ctrl + Page Up/Down to move between sheets but if you're in the middle of a drag that won't work.

Some people just use the Cut/Paste routine which absolutely works but what if that's not your first instinct? What if the drag and drop is just the way you naturally work? Is there a solution for you?

I'm glad to report that the answer is yes.

Next time you're dragging the data, simply hold down the Alt key and the scrolling will stop.

Once you've got the scrolling stopped you'll find that you're allowed access to the sheet tabs.

While still holding the mouse button as a part of the drag, highlight a different sheet tab and poof!

You're on a different worksheet where you can easily complete the "drop" part of the data movement using your preferred method.