Did you know that Excel can calculate a different way than by creating formulas? A little bit different procedure demonstrates this video. You can actually change the selected value via the “Paste Special” option. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too.
Please note that this tutorial is presented in czech language.
Source file can be downloaded here.