how do i multiply a column when i copy it in excel for mac?

How Do I Multiply A Column When I Copy It In Excel ? How To Use AUTO

After watch this quick Trick Blogs so excited to use First Time.

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, Id like to show you how can you use paste special to multiply and (subtract, divided, and minus) as well.

Multiply in Excel using Paste Special Option Lets say, you have a data table with call tariff rates from India to other countries.

Now, rather than using the formula you can use paste specials multiply option here.

Select the cell in which you have your age of increment(I have used 1.2 for increasing the tariff by 20) and copy it.

Now, select the entire range on which you want to apply the calculation.

Use shortcut key Alt E S to get the paste special dialog box.

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.

And When You have Cells with Formulas 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.

Paste Special for Dynamic Calculations One more useful thing you can do with paste-special is, you can perform a dynamic calculation.

Lets 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.

Shortcuts Keys Multiply - Alt V H M Divide - Alt V H I Add - Alt V H D Subtract - Alt V H S Conclusion 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.

Have you ever tried this before Share your views with me in the comment box, Id love to hear from you.

How Do I Multiply A Column When I Copy It In Excel ? How To Use AUTO

Share 0 Tweet 0 Must Read Next 5-Popular Ways to Concatenate a Range of Cells in Excel 10 Powerful Double Click Mouse Tricks For Excel Power Users The Best 4 Ways to Count Words in Excel Cell Range Worksheet How To Use AUTO FORMAT Option in Excel Time Saver Tip Perfect 5 Ways To Apply Strikethrough in Excel Shortcut Command How to Convert a Formula to Value in Excel About the Author Puneet is using Excel since his college days.

He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel.

You can nd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

Learn Excel (Videos) Connect with Puneet 15 Comments 15 thoughts Leave a Comment Cancel reply Your email address will not be published.

Comment Name Email Website Mohamed Younus 26 Nov, 19 at 7:28 am Excellent Reply Harmesh Kumar 5 Oct, 19 at 11:26 am Wow You are Genius Sir, I like all your Trick.

How Do I Multiply A Column When I Copy It In Excel For Mac?