Multiply using PasteSpecial

Hello All,

This post will help you learn a smarter way to multiply a range of data with a single number. For example below in Column A we have 5 products and column B contains their corresponding price.
Multiply with PasteSpecial
Now if you want to multiply the price by say 10%. You can do that smartly,  using the method I am going tell. 

Enter 1.1 into any blank cell (like D1)
Multiply with PasteSpecial
Select the cell and choose Edit, Copy.
Select the range of values and choose Edit, Paste Special.
Multiply with PasteSpecial
Choose the Multiply option and click OK.
PasteSpecial


















Delete the cell that contains the 1.1. 
Your final result will look like this. 
PasteSpecial
HAPPY LEARNING :) 

2 comments:

  1. Oh.. Paste with multiplication...It's very useful. But I rarely used it before

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete