How to Paste Numbers Only [quick tip]

Sometimes when you are working with data, you may need to just copy and paste numbers from one range to another. Here is a handy little trick to achieve that.

Use Paste Special > Add operator to paste numbers only.

1. Select the source range, press CTRL+C
2. Now, go to target range, press ALT+E and then S to activate paste special dialog
3. Select “Add” operator (you can press d)
4. Click ok.

See this short screen-cast to understand how to do this:

Bonus tips:

Convert numbers from positive to negative:

1. Select and copy a bunch of numbers
2. Go to an empty cell, press ALT+E and then S and then S (or choose subtract operator)
3. That is all. Your numbers are negated now.

Convert from one currency to another instantly:

1. Enter the exchange rate in a cell. Copy it.
2. Now select all the cells which needs to be converted.
3. Press ALT+E and then S and then select Multiply operator (press m)
4. That is all. Your currencies are converted. That will be $2.00 plus 1$ per 100.

16 more tricks on how to use paste special

Do you use Paste Special? Share your tips:

I love paste special as much as my wife loves pastries. And that is a high praise. What about you? Do you use paste special? Tell me and our readers how you use it. We are all ears.

Here is a chance to be awesome:

Learn a quick tip today or share a link to win a gift card [expires on 12th Sept, 2010].