add same number to a column of numbers

D

djs

How do i add .25 to a column of 15 different numbers at one time instead of
doing it separately.
 
B

Barb Reinhardt

Let's say you have the 15 different numbers in A1:A20
In B1 put =A1+.25
Copy that down to B20
 
N

Niek Otten

Or: enter .25 in an empty cell. Edit>Copy.Select A1:A20
Edit>Paste Special, check Add

--
Kind regards,

Niek Otten

| Let's say you have the 15 different numbers in A1:A20
| In B1 put =A1+.25
| Copy that down to B20
|
| | > How do i add .25 to a column of 15 different numbers at one time instead
| > of
| > doing it separately.
|
|
 
D

djs

I want to add the .25 to the same column. i.e if i highlight A1 to A15 then
somehow add +.25 then all the numbers in the A column would increase by .25
 
Top