Excel Paste Special functionality can save a lot of time. One of its features is ‘Operations’, which allows us to quickly perform mathematical calculations (such as addition, subtraction, multiplication, and division) on a range of cells. In this tutorial, I will show you how to multiply in Excel using paste special operators options. These come in handy when you want to avoid applying formulas or using helper columns. Suppose you have the data set as shown below. These are sales forecast numbers, and you need to increase these forecast values by 10%. One way (the long and tedious one) to do this is to use a helper column and first calculate new values by a formula, and then paste the new values in place of old values. Another (quick and awesome) way is to use the Paste Special Operation feature.
How to Multiply in Excel Using Paste Special
Here are the steps to multiply in Excel using the Paste Special Operations: This will replace old numbers with new numbers.
What If You have the Numbers as Result of a Formula
No Problem at all!! This trick works with numbers as well as formulas. Suppose you have a formula A1+A2 in a Cell, and you want to multiply the result with a number 1.1 (which is in cell E2). Follow the same steps, as shown above, and you would get the desired result. However, note that when you use mathematical operations with a formula, it is inserted as a part of the formula (see below)
What if You want to Change every Nth Value Only?
Yes, you can!! Suppose you want to revise the forecast numbers for Fourth Quarter Only (while the remaining numbers should be the same). This can be done using Paste Special Operation Feature with this nifty tip. Instead of a single value, use a range of four values (as shown below): Copy these four cells instead of a single cell, and follow the same steps as described above. This works by multiplying the first 3 values with 1 and the fourth with 1.1, and so on. Cool Trick, Isn’t It!!
10 Super Neat Ways to Clean Data in Excel Spreadsheets.24 Daily Excel Issues and their Quick Fixes.200+ Excel Keyboard Shortcuts.Show Formulas in Excel Instead of the Values.Understanding Absolute, Relative, and Mixed Cell References in Excel.How to Transpose Data in Excel.What is Intersect Operator in Excel and How to Use itHow To Subtract In Excel (Subtract Cells, Column, Dates/Time)Calculate Percentage Change in Excel (% Increase/Decrease Formula)How to Multiply a Column by a Number in Excel (2 Easy Ways)
