View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default Multiplying a column of data by a constant

Try this:

Enter 1.1 in an empty cell
Copy that cell: EditCopy
Select the range of cells you want to increase
Goto EditPaste SpecialMultiplyOK
Delete the 1.1

Biff

"Zach" wrote in message
...
I am budgeting costs for the upcoming year. There is a column of data that
corresponds to the employee's health insurance cost that is keyed in data
(not a formula). I want to multiply each cell in this column by 1.1 to
project a 10% increase in cost. Is there quick way to do this without
creating a new column and pasting over the original?