In our Where Is it Wednesday podcast, we go looking for a command that most people never would have been able to find in Excel 2003! If you want to send a perfect copy of a formatted spreadsheet in an e-mail, you could use Snag-It or PrtScrn, but by holding down the shift key, you can find a hidden Copy as Picture command in Excel 2003. Episode 858 shows you how.
Transcript of the video:
Hey, alright, welcome back to "Where Is It Wednesday".
Want to thank George Wood for that great theme.
Now, this "Where Is It Wednesday", most of you probably weren't even aware that the feature was in the old Excel.
Let's say that you need to copy the look of this spreadsheet to an email or something like that, well, you could use Snagit.
Snagit as a great utility from TechSmith; I use Snagit all the time.
But if you don't have Snagit, you are stuck using Print Screen.
So we could press the Print Screen button and then go over to our email, and do Ctrl+V to paste, and it's going to paste the whole screen-- that's not what we want to do.
We want to paste just the relevant section of the screen.
So, here's an amazing trick-- it was in Excel 2003.
Let's select just the section we want to send-- so, this Pivot Table here.
And you know that Edit normally has something called Copy, but we're not going to use Copy here; instead, I'm going to hold down the Shift key-- hold down the Shift key-- when i go to the Edit menu, and we now have Copy Picture-- Copy Picture, "As shown on screen".
Click OK, and switch back to the email and do Ctrl+V to paste, and we get a perfect picture of the spreadsheet.
Okay, now in Excel 2007, how do we do the same thing?
So, we have some data in Excel 2007, and we want a picture of that data.
Well, here's the copy icon, and if I hold down the shift key, it unfortunately still does copy-- it doesn't know that old Shift trick.
So we're going to have to go in, right-click the Quick Access toolbar, choose Customize, and then we're going to go to All Commands; when we have All Commands, go down to the Cs-- it's called Copy as Picture.
So the nice thing about All Commands is, it's arranged alphabetically-- not in any particular ribbon sequence.
So now we have Copy as Picture, we'll add that, click OK.
And now, to do the exact same thing, I'll select my data, I'll click Copy as Picture, and of course, they use the green crystal ball icon that they use about a hundred times, so you'll have to hover to see what it is.
Copy as Picture, "As shown on screen", and we can switch back to our email and paste to get a picture of the data.
Great feature that I think not many people knew was in the old Excel, because you had to hold down the Shift key to find it.
But if you're a person who used it and you switch over to 2007, you're going to have to add the icon to the Quick Access toolbar.
Hey, it's Wednesday here, and just last week we had put up a brand new version of the MrExcel.com website.
If you have a chance, just go out and visit the site, take a look around-- we tried to make things a little bit simpler to find, tried to organize some things, added, you know, what I think a better navigation up there at the top.
Take a look, let me know what you think, shoot me an email to bill@MrExcel.com, and any comments, positive or negative, like to know what you think of the new website.
We'll be working on getting this look and feel throughout the site over the next coming weeks and months.
I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
[ music ]
Want to thank George Wood for that great theme.
Now, this "Where Is It Wednesday", most of you probably weren't even aware that the feature was in the old Excel.
Let's say that you need to copy the look of this spreadsheet to an email or something like that, well, you could use Snagit.
Snagit as a great utility from TechSmith; I use Snagit all the time.
But if you don't have Snagit, you are stuck using Print Screen.
So we could press the Print Screen button and then go over to our email, and do Ctrl+V to paste, and it's going to paste the whole screen-- that's not what we want to do.
We want to paste just the relevant section of the screen.
So, here's an amazing trick-- it was in Excel 2003.
Let's select just the section we want to send-- so, this Pivot Table here.
And you know that Edit normally has something called Copy, but we're not going to use Copy here; instead, I'm going to hold down the Shift key-- hold down the Shift key-- when i go to the Edit menu, and we now have Copy Picture-- Copy Picture, "As shown on screen".
Click OK, and switch back to the email and do Ctrl+V to paste, and we get a perfect picture of the spreadsheet.
Okay, now in Excel 2007, how do we do the same thing?
So, we have some data in Excel 2007, and we want a picture of that data.
Well, here's the copy icon, and if I hold down the shift key, it unfortunately still does copy-- it doesn't know that old Shift trick.
So we're going to have to go in, right-click the Quick Access toolbar, choose Customize, and then we're going to go to All Commands; when we have All Commands, go down to the Cs-- it's called Copy as Picture.
So the nice thing about All Commands is, it's arranged alphabetically-- not in any particular ribbon sequence.
So now we have Copy as Picture, we'll add that, click OK.
And now, to do the exact same thing, I'll select my data, I'll click Copy as Picture, and of course, they use the green crystal ball icon that they use about a hundred times, so you'll have to hover to see what it is.
Copy as Picture, "As shown on screen", and we can switch back to our email and paste to get a picture of the data.
Great feature that I think not many people knew was in the old Excel, because you had to hold down the Shift key to find it.
But if you're a person who used it and you switch over to 2007, you're going to have to add the icon to the Quick Access toolbar.
Hey, it's Wednesday here, and just last week we had put up a brand new version of the MrExcel.com website.
If you have a chance, just go out and visit the site, take a look around-- we tried to make things a little bit simpler to find, tried to organize some things, added, you know, what I think a better navigation up there at the top.
Take a look, let me know what you think, shoot me an email to bill@MrExcel.com, and any comments, positive or negative, like to know what you think of the new website.
We'll be working on getting this look and feel throughout the site over the next coming weeks and months.
I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
[ music ]
