The best way to Add or Multiply Values with Paste Particular in Microsoft Excel

Microsoft Excel Logo

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

Right-click the cell and pick 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.

Right-click and pick Paste Special

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.

RELATED: How to Paste Text Without Formatting Almost Anywhere

You’ll then use the part labeled Operation so as to add, subtract, multiply, or divide.

Paste Special options

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.

Copy the cell with the number you want to add

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

Select Add before hitting OK

And there we go! The entire cells in our choice have elevated by $100.

Amount added using Paste Special

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.

Copy the cell with the number you want to subtract

Choose the cells to stick to and open Paste Particular. Select “Subtract” and click on “OK.”

Select Subtract before hitting OK

Identical to with addition, the quantity is subtracted from our cells, and we will transfer on to promoting extra jackets.

Amount subtracted using Paste Special

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.

Copy the cell to multiply

Choose the cells to stick to, open Paste Particular, choose “Multiply,” and click on “OK.”

Select Multiply

And there we have now it! We simply quadrupled our numbers in a single fell swoop.

Amount multiplied using Paste Special

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.

Copy the cell to divide

Choose the cells to stick to, open Paste Particular, choose “Divide,” and click on “OK.”

Select Divide

And similar to that, our stock has decreased by half.

Amount divided using Paste Special

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.

Source link

Recent Articles


Related Stories

Leave A Reply

Please enter your comment!
Please enter your name here

Stay on op - Ge the daily news in your inbox