View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Multiplying a column of data by a constant

Zach

Put 1.1 in an unused cell.

Copy it.

Select your data range and EditPaste SpecialMultiplyOKEsc.

Delete cell with the 1.1


Gord Dibben MS Excel MVP


On Thu, 19 Oct 2006 11:30:02 -0700, Zach wrote:

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?