Tip 267 – Quickly multiply a range of numbers by a given number

If you have a range of numbers, pricing for example, and you want to multiply the entire range by the same number, say by 0.95 to apply a 5% discount, or 1.05 to apply a 5% increase, type the coefficient you want to use in an empty cell. Copy that cell and select the cells you want to apply the multiplication to. On the home tab, click the Paste dropdown list and select Paste Special. Select the Multiply option and then click ok.