Tip #3003 - Drag and Drop Between Worksheets
Printer Friendly Version | E-Mail This Tip
Drag
and Drop Between Worksheets
So, you've got some
data in an Excel worksheet that you need to move to a new location.
The only thing, it's
within the same sheet. Well, that's no problem!
I'm positive that
we all know about highlighting the data to be moved and then using the
mouse pointer on the very edge of the selected cell(s) to click and drag
the data to a new location.
It's quick and easy,
so what could be wrong with that?
Well, nothing, unless
you're looking to relocate the data to a different worksheet within the
workbook.
Have you ever tried
that?
Yes?
Then you know what
happens.
You drag the cells
down toward the sheet tabs and instead of being able to select a new worksheet
to go to, the current worksheet starts scrolling down!
Okay, so what's the
deal with that?
You could copy/paste
to a different sheet, but you like this drag and drop thing better. And
let's face it, you're already halfway through that process. No one wants
to start all over again!
So, what now?
Good question, but
I've got an even better answer!
Try pressing the Alt
key.
Yep, that's it. That's
the whole trick.
When you press the
Alt key (while still holding down the mouse button),
the scrolling downward will stop and you'll be allowed to slide back and
forth along the sheet tabs.
As you move over the
sheet tabs, you'll notice the sheets change, so just find the worksheet
you need and simply move up into the worksheet to drop the data in its
new location.
And that's it!
Alt
is the whole key to dragging and dropping across worksheets!
~ April
Want To Comment On This Tip? Click Here! We'd love to hear from you :-)
Like These Tips? Get 'Em Free In Your E-mail
