Inserting a fixed value in to hundereds of cells

  • Thread starter Thread starter Wayne Wells
  • Start date Start date
W

Wayne Wells

I have 3 years worth of daily data in a spreadsheet. To "normalize" the data,
I am requred to add the first cell value to each of the subsequent cells.
=sumD4-D4 ---This will yield a zero starting point
=sumD5-D4
=SUMD6-D4
=SUMD7-D4
and on and on and on.

I need to subrtact D4 from hundreds of lines of data and there has top be a
better way than doing each one, line by line.
 
* In a free cell type the value of A4.
* Press CTRL+C for "copy"
* Select the 1095 cells > RIGHT(!) click on one of them > 'PasteSpecial' >
mark 'SUBTRACT' > 'O.K.'
That is all
Micky
 
As you can imagine, my previous suggestion will change ALL cell values in
Column. D
If you don't care to use an helper-column (E) then you may consider to type,
in cell E5, the formula: =D5-$D$4 and to copy it, down ,along the 1065 cells.
Micky
 
Back
Top