I've shown how to make copies of a worksheet within a workbook before, but in today's podcast, someone asks if you can drag a worksheet to a new workbook. Episode 850 shows you how. Also - in honor of the 750th podcast episode, a new contest for Saturday.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Here we are, Episode number 850, and since I started at Episode number 101, this is our 750th Podcast.
Never ever thought it would go on this long-- three-quarters of the way to a thousand.
Now, I've shown this trick before: If we need to make a copy of a worksheet, most of the time people right-click, Move or Copy, choose Create a Copy, and on and on and on.
In the podcast, I've shown how you hold down the Ctrl key, and you can basically make a copy of the worksheets very, very quickly.
So, if you need to snap out 11 copies of January, you can just Ctrl+drag, Ctrl+drag, Ctrl+drag, and so on.
I was doing a seminar and someone said, "Well, okay, that's cool but Move or Copy lets you copy to another workbook-- how can you do that to copy to another workbook?" I never tried it, but it's amazing that it works.
Do Window; Arrange Verticals that we can see the two workbooks side by side; and then, sure enough, just Ctrl+drag from one workbook to the other workbook and it will copy that data from one place to the other.
You know, in honor of our 750th Episode, let's do something crazy here.
Out at Facebook, for people to sign up to be fans of MrExcel on Facebook, we have a drawing every week and it's a book or something like that.
But this is kind of an exciting week because we hit number 750-- 750 podcast.
Just go to Facebook, look for MrExcel.com, and then up here in the upper right-hand corner say Add as Fan-- Join as Fan, that'll be up there.
Now, I'm the administrator, so you don't see that.
Then what we're going to do on Saturday, the 20th, when we have the drawing from all the Facebook fans, we're going to allow someone to choose their favorite color of the new iPod Nano.
So you can choose whatever color you want, get an 8 Gigabyte Nano, and that'll be our prize this week.
Want to thank you for stopping by, wanna thank you for watching all these pods or however many of them you've happened to watch, and we'll see you next time for another netcast for MrExcel.
[ music ]
Here we are, Episode number 850, and since I started at Episode number 101, this is our 750th Podcast.
Never ever thought it would go on this long-- three-quarters of the way to a thousand.
Now, I've shown this trick before: If we need to make a copy of a worksheet, most of the time people right-click, Move or Copy, choose Create a Copy, and on and on and on.
In the podcast, I've shown how you hold down the Ctrl key, and you can basically make a copy of the worksheets very, very quickly.
So, if you need to snap out 11 copies of January, you can just Ctrl+drag, Ctrl+drag, Ctrl+drag, and so on.
I was doing a seminar and someone said, "Well, okay, that's cool but Move or Copy lets you copy to another workbook-- how can you do that to copy to another workbook?" I never tried it, but it's amazing that it works.
Do Window; Arrange Verticals that we can see the two workbooks side by side; and then, sure enough, just Ctrl+drag from one workbook to the other workbook and it will copy that data from one place to the other.
You know, in honor of our 750th Episode, let's do something crazy here.
Out at Facebook, for people to sign up to be fans of MrExcel on Facebook, we have a drawing every week and it's a book or something like that.
But this is kind of an exciting week because we hit number 750-- 750 podcast.
Just go to Facebook, look for MrExcel.com, and then up here in the upper right-hand corner say Add as Fan-- Join as Fan, that'll be up there.
Now, I'm the administrator, so you don't see that.
Then what we're going to do on Saturday, the 20th, when we have the drawing from all the Facebook fans, we're going to allow someone to choose their favorite color of the new iPod Nano.
So you can choose whatever color you want, get an 8 Gigabyte Nano, and that'll be our prize this week.
Want to thank you for stopping by, wanna thank you for watching all these pods or however many of them you've happened to watch, and we'll see you next time for another netcast for MrExcel.
[ music ]
