[kittycatvet]

I have a range of cells and want to subtract a value from each cell. Can I
do that without having to do each one individually? Here is a very shortened
example of what I am doing. I need to make the start value 0. To do that, I
need to subtract 2 from each of the cells. Is there a way I can subtract 2
from each cell in the row?

Start Value 5 min 10 min 15 min ............... 120
min
2 2 4 4
.................11 ml

[Dennis Tucker]

kittycatvet,

copy the cell with the value 2, then select the other values, use 'paste
special and choose subtract. the value you copied will be sutracted from
the other values.

dennis

"kittycatvet" wrote in message
...
I have a range of cells and want to subtract a value from each cell. Can
I
do that without having to do each one individually? Here is a very
shortened
example of what I am doing. I need to make the start value 0. To do
that, I
need to subtract 2 from each of the cells. Is there a way I can subtract
2
from each cell in the row?

Start Value 5 min 10 min 15 min ...............
120
min
2 2 4 4
................11 ml