You may copy and paste knowledge usually in your spreadsheets. However do you know that you need to use Excel’s paste characteristic to perform simple calculations? You may add, subtract, multiply, or divide in just a few clicks with paste particular in Excel.
Perhaps you might have prices that you want to increase or prices that you simply wish to lower by greenback quantities. Or, maybe you might have stock that you simply wish to enhance or lower by unit quantities. You may carry out all these calculations rapidly on numerous cells concurrently with Excel’s paste particular operations.
Entry Paste Particular in Excel
For every of the aforementioned calculations, you’ll open the Paste Particular dialog field in Excel. So, you’ll begin by copying the information after which choosing the cell(s) that you simply’re pasting to.
To repeat, you possibly can press Ctrl+C or right-click and choose “Copy.”
Then, do one of many following to entry paste particular.
- Click on the Paste drop-down arrow within the ribbon on the Residence tab. Choose “Paste Particular.”
- Proper-click the cells that you simply’re pasting to and choose “Paste Particular” within the shortcut menu.
Add, Subtract, Multiply, or Divide Utilizing Paste Particular
For primary numbers, decimals, and forex, you possibly can select from All, Values, or Values and Quantity Codecs within the Paste part of the window. Use the best choice for your particular data and formatting.
You’ll then use the part labeled Operation so as to add, subtract, multiply, or divide.
Let’s take a look at a easy instance of every operation to see the way it all works.
Add and Subtract with Paste Particular
For this instance, we wish to add $100 to every of the quantities for our jacket costs to accommodate a rise.
We enter $100 right into a cell outdoors of our knowledge set and replica it. You may have already got the information in your sheet or workbook that it is advisable to copy.
Then, we choose the cells that we wish to add $100 to and entry Paste Particular as described. We select “Add” within the Operation part and click on “OK.”
And there we go! The entire cells in our choice have elevated by $100.
Subtracting an quantity works the identical manner.
Copy the cell containing the quantity or quantity that you simply wish to subtract. For this instance, we’re lowering the costs of our jackets by $50.
Choose the cells to stick to and open Paste Particular. Select “Subtract” and click on “OK.”
Identical to with addition, the quantity is subtracted from our cells, and we will transfer on to promoting extra jackets.
Multiply and Divide with Paste Particular
For the multiplication and division examples, we’re going to make use of numbers as an alternative of forex. Right here, we wish to quadruple the quantity of stock for our jackets as a result of we acquired a cargo.
We enter the quantity four right into a cell outdoors of the information set and replica it. Once more, you might need the information that it is advisable to copy elsewhere already.
Choose the cells to stick to, open Paste Particular, choose “Multiply,” and click on “OK.”
And there we have now it! We simply quadrupled our numbers in a single fell swoop.
For our last instance, we have to divide our stock numbers in half as a consequence of lacking merchandise. Copy the cell containing the quantity or quantity to divide by. For us, the quantity is 2.
Choose the cells to stick to, open Paste Particular, choose “Divide,” and click on “OK.”
And similar to that, our stock has decreased by half.
Make sure to swap the operation again to “None” once you’re completed.
The subsequent time it is advisable to add, subtract, multiply, or divide a big group of cells in Excel by the identical quantity, bear in mind this trick utilizing paste particular. And for associated assist, see tips on how to copy and paste in Outlook with attention to formatting.