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.
- Select the source range, press CTRL+C
- Now, go to target range, press ALT+E and then S to activate paste special dialog
- Select “Add” operator (you can press d)
- Click ok.
See this short screen-cast to understand how to do this:
Bonus tips:
Convert numbers from positive to negative:
- Select and copy a bunch of numbers
- Go to an empty cell, press ALT+E and then S and then S (or choose subtract operator)
- That is all. Your numbers are negated now.
Convert from one currency to another instantly:
- Enter the exchange rate in a cell. Copy it.
- Now select all the cells which needs to be converted.
- Press ALT+E and then S and then select Multiply operator (press m)
- 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].
12 Responses to “Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster”
A great tribute to one of the greatest batsmen's in Cricket history.
Thanks Chandoos!
A fantastic poster, Chandoo. I suspect most people would assume it was done in Adobe Illustrator.
Great work!
Daniel Ferry
excelhero.com/blog
[...] Visit his post to download the excel file: Sachin Tendulkar Statistics Excel Infographic Poster [...]
[...] Courtesy: Wikipedia.org >> Chandoo.org [...]
Please update the pingback url to http://www.newsilike.in/sachin-tendulkar-infographics/
Awesome man .....super work
[...] Wikipedia.org >> Chandoo.org ← Previous Next [...]
[...] Kummi in Blog, Dashboard, Excel, Infographic | No Comments Jan252012 Chandoo.org published an infographic poster created in Excel. As a big fan of Tendulkar, I really liked this [...]
[...] Via Tags: europe, football, european league, soccer, sports © 2012 Latest Infographics /* */ [...]
[...] Source [...]
[...] Link [...]
[…] Source […]