A lull in the action this week gives me time to talk about Excel 2010.
Every day this week, I’ll take time to blog about some of the new features in Excel 2010 that strike me as real improvements.
Today, I’d like to talk about the improvements in the Paste Special functionality in Excel 2010.
Anyone who has used Excel for more than a week will know just how much the ‘Paste Special’ functionality is ingrained in our daily activities. So when Microsoft makes improvements to this functionality, it’s time for a love fest.
From my perspective, there are two major improvements that will come in handy: WYSIWYG Paste Special, and One Touch Paste Special.
I made these terms up because…frankly…I’m too lazy to look up Microsoft’s official terminology for these two new features.
WYSIWYG Paste Special
In Excel 2010, when you copy a range and right click anywhere in the spreadsheet, you get a right-click menu that shows you the Paste Special icons.
Hovering over these, you can see a live preview of what the each Past Special command will do to your data. In this screenshot, I’m hovering over the Transpose icon. As you can see, Excel 2010 shows me what my dataset would look like if I executed this Paste Special command. Nice!
One Touch Paste Special
I found that it’s sometimes easier to execute a normal paste then use the smart tag menu that activates in Excel 2010.
That is, copy the source data, then do a standard paste (Ctrl+V) where you want. At this point Excel 2010 will activate a smart tag that allows you to expand a small menu of Paste Special commands.
Simply click the command you want, and you’re done. You can also use Hot Keys to execute these Paste Special commands.
There you have it!
I’m sure many of you will sooner Barbecue your family pet than stop using your tried and true hot key combination for Paste Special Values. But you have to admit that Paste Special sure has come a long way – from being practically hidden in Excel 2000 to in-your-face functionality in Excel 2010.
As a side note: Mrs. Pig told me that she wishes she can take Hugh Jackman’s body and do a Paste Special Formats on top of mine. Did she just call me fat?