The Robservatory

Robservations on everything…



How to: Simplify value pasting in Excel

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.

Excel dialogSometimes 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.


Review of Excel for iPad

Macworld logoI 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.

Read the rest over at Macworld.

The Robservatory © 2018 • Privacy Policy Built from the Frontier theme