A preview of new features coming in Excel 2010: Episode 1066 shows you the Paste Options shortcuts in Excel 2010.
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 MeExcel netcast, I'm Bill Jelen.
Wow! We're going to take a look at Excel 2010 today.
Now, this isn't coming out until first quarter of next year, maybe even April, but the technical preview is out and I'm in that beta group now.
Normally if you're in the beta there's an NDA and you're not allowed to talk about anything but this year really strange they said that we could talk about the features in the client, there's other things they want to keep secret I can't tell you about those, but anything that's here in the Excel 2010 client we can talk about and this week we're going to take a look at the features that are coming in Excel 2010.
Now my favorite one here is not one that you're going to see Microsoft talk about; it is something that I discovered and is just a huge time-saver.
Let's say that we have this table here it has some formulas, has some formatting, and I want to copy that table and I want to paste values and number formatting.
Well in the past that would be Open Paste, choose Paste Values and then we go into Paste Special and choose formats, and click OK, so it was a couple of operations, oh!
And then the column widths are wrong have to go back into Paste Special and choose column widths, all right so it was like three operations that we had to do.
What a pain that is!
Check out the new feature in Excel 2010, I copy with CTRL C, come down here CTRL V to paste, and you'll notice that paste options now has a control shortcut key, so we press CTRL and release, we now get to paste options let's take a look at what's in here, well if we press B right now we would paste values, okay we've been able to do that for a while, values in numeric formatting great, values and source formatting; this is huge, this is from the customer experience improvement data they realized that most of the time after people paste values they then go back and do paste formatting to get the formats as well, so we see the shortcut key there is E and then also up here column width, source columnist; that would be W, so those are a couple of great options.
Let's undo this here and I'll copy my original data, let's try it CTRL C, now come down here, CTRL V to paste, I press control again and then E, now I've copied values and number formatting, CTRL again and W, and brought the column what's over a couple of great features there, there are a lot of features that came along in Excel 2007 even more features that came along and Excel 2010 you know but frankly they were glitz and glitter, and not things I would ever use this shortcut key I've learned these, I've started to use them it's very frustrating when I'm back in 2003, 2007 and I can't just hit that second control and the E, or the second control and the W to copy column, it over now, a brilliant bit of very tiny thing the marketing people will never mention this because they don't realize it, but you the people that use Excel 40 hours a week and have to do paste special values or paste special formats will recognize this as a huge time saver.
That's my first tip that I wanted to show from Excel 2010, we'll take a look at other things; things that Microsoft is talking about but this by far is a tiny little feature there's going to be a huge time-saver.
I want to thank you for stopping by; we'll see you next time for another netcast for MrExcel.
Wow! We're going to take a look at Excel 2010 today.
Now, this isn't coming out until first quarter of next year, maybe even April, but the technical preview is out and I'm in that beta group now.
Normally if you're in the beta there's an NDA and you're not allowed to talk about anything but this year really strange they said that we could talk about the features in the client, there's other things they want to keep secret I can't tell you about those, but anything that's here in the Excel 2010 client we can talk about and this week we're going to take a look at the features that are coming in Excel 2010.
Now my favorite one here is not one that you're going to see Microsoft talk about; it is something that I discovered and is just a huge time-saver.
Let's say that we have this table here it has some formulas, has some formatting, and I want to copy that table and I want to paste values and number formatting.
Well in the past that would be Open Paste, choose Paste Values and then we go into Paste Special and choose formats, and click OK, so it was a couple of operations, oh!
And then the column widths are wrong have to go back into Paste Special and choose column widths, all right so it was like three operations that we had to do.
What a pain that is!
Check out the new feature in Excel 2010, I copy with CTRL C, come down here CTRL V to paste, and you'll notice that paste options now has a control shortcut key, so we press CTRL and release, we now get to paste options let's take a look at what's in here, well if we press B right now we would paste values, okay we've been able to do that for a while, values in numeric formatting great, values and source formatting; this is huge, this is from the customer experience improvement data they realized that most of the time after people paste values they then go back and do paste formatting to get the formats as well, so we see the shortcut key there is E and then also up here column width, source columnist; that would be W, so those are a couple of great options.
Let's undo this here and I'll copy my original data, let's try it CTRL C, now come down here, CTRL V to paste, I press control again and then E, now I've copied values and number formatting, CTRL again and W, and brought the column what's over a couple of great features there, there are a lot of features that came along in Excel 2007 even more features that came along and Excel 2010 you know but frankly they were glitz and glitter, and not things I would ever use this shortcut key I've learned these, I've started to use them it's very frustrating when I'm back in 2003, 2007 and I can't just hit that second control and the E, or the second control and the W to copy column, it over now, a brilliant bit of very tiny thing the marketing people will never mention this because they don't realize it, but you the people that use Excel 40 hours a week and have to do paste special values or paste special formats will recognize this as a huge time saver.
That's my first tip that I wanted to show from Excel 2010, we'll take a look at other things; things that Microsoft is talking about but this by far is a tiny little feature there's going to be a huge time-saver.
I want to thank you for stopping by; we'll see you next time for another netcast for MrExcel.
