Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Sometimes in Excel, you need to perform some quick calculations. And, you can use paste special for these quick calculations instead of formulas.
In paste special, you have four different options [Add, Subtract, Multiply, and Divide] which you can use.
And today in this post, I'd like to show you how can you use paste special to multiply and (subtract, divided, and minus) as well.
Let’s say, you have a data table with call tariff rates from India to other countries. And due to some hike in cost, you need to increase your tariff rates by 20%.
Now, rather than using the formula you can use paste special's multiply option here.
In the above example, we have used an increased rate of multiplication. You can use the same way to add, subtract, and divide as well.
Now, this is one of the most amazing things you can do with paste special. If you have some cell where you already have formulas, you can still use paste special.
In above example, the price is the sum of fixed cost (E2) and variable cost (E3). We have increased the price by 32.25%.
One more useful thing you can do with paste-special is, you can perform a dynamic calculation.
Let's say, you have a data set of five products for different zones and you have to calculate an incremental price for all the five products using different incremental rate.
Just select the all the cells having incremental rates and follow the same steps which we have used above.
Using paste special to multiply and for other small calculations is a time saver. If those calculations are one time then there is no need to use formulas.
This method is quick, simple, and easy.
Now tell me one thing. Have you ever tried this before?
Share your views with me in the comment box, I'd love to hear from you. And, please don't forget to share this tip with your friends.
Must Read Next