I tweeted this over the weekend, but thought it might be worth a bit more explanation here. By default, when you copy and paste something in Excel, Excel defaults to pasting everything from the copied cell: the formula, shading, borders, font, style, etc.
Sometimes this is OK, but often I just want the values from a cell or range—either because I’m using them in another table with different formatting, or to convert a formula into fixed values.
Out of the box, if you want to paste just the cell values in Excel, you have to select Edit > Paste Special, then navigate the world’s busiest dialog box (as seen at right), click on the tiny Values radio button, then hit Return.
If you’re doing a lot of value pasting, this is a royal pain. Thankfully, it’s pretty easy to fix this design stupidity.
How you fix this depends—for the first step—on whether you’re running Excel 2008 or Excel 2011.
I spent some time (a lot of time, actually) with Excel for the iPad, and reviewed it for Macworld:
There are any number of spreadsheet apps available for the iPad, but recently the market changed dramatically when Microsoft released the full Office suite for iPad, including a version of Excel. While you can argue that Excel is many years late to the iPad party (and I wouldn’t disagree), the iPad version of Excel is a solid entrant, and instantly changes the landscape for competitive apps.