Excel – How to Multiply Data in a Column (Excel 2003, Excel 2007, Excel 2010)
Using “Paste Special” with a ‘Multiplier’ will allow you to take selected data and multiply it by a specific percentage in just a few quick steps. In this example we will give a 5% raise across the board to a list of employees.