Inserting a fixed value in to hundereds of cells
 

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.

Inserting a fixed value in to hundereds of cells
 

* 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



"Wayne Wells" wrote:

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.

Inserting a fixed value in to hundereds of cells
 

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


"מיכאל (מיקי) אבידן" wrote:

* 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



"Wayne Wells" wrote:

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.