Hey, welcome back to the Mr. Excel netcast. I’m Bill Jelen. Wow! We’re going to take a look at Excel 2010 today.
Now this is incoming out until the first quarter of next year maybe even April, but the technical preview is up and in that data grid now. Normally if you’re in the data there’s an NDA you are not allowed to talk about anything, but this year really strange they say that we could talk about the features in the client.
There are other things I want to keep secret. I can’t tell you about those, but anything that’s here in Excel 2010 client we can talk about, and this week we’re going to take a look at the features they 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, huge time saver. Let’s say that we have this table here. It has some formulas. It has some formatting, and I want to copy that table and I want to paste values and number formatting.
Well, in the past there be open paste, choose paste values and then we go into paste special and choose formats and click OKAY, so there’s a couple of operations and then the column which are right here have to go back in the paste special and choose column width. Alright, so it is like three operations that we have 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 the paste options now has a Ctrl shortcut keys.
So we press control and release we now get the paste options. Let’s take a look at what’s in here. We press V right now. We will paste values. We’ve been able to do that for a while, values and numeric formatting, great. Values and source formatting, this is huge. This is from the customer’s experience improvement data. They’ve 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 short cut key there is E and then also appear column width, source column is that will be W so those are couple of great options. Let’s undo this here and I’ll copy my original data. Let’s try it, Ctrl-C now. I come down here Ctrl-V to paste. I’ll press Ctrl again and then E, now I’ve copied values and number formatting, Ctrl again and W and brought the column which is 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 in Excel 2010. You know, but frankly they were cleats and encoder and those things I would ever use. This short key, I’ve learned this. I’ve started to use them. It’s very frustrating when I’m back in 2003 or 2007 that I can’t just hit that second Ctrl and the E or the second Ctrl and the W to copy column which is over. 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. Now you have to do paste special values or paste special formats will recognize this as a huge, huge time saver. That’s my first tip that I want to show in 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 that can be huge time saver. I want to thank you for stopping by we’ll see you next time for another netcast from Mr. Excel.
Transcription by:
Scribe4you Transcription Services