How do I add the same number/value for an entire column in Excel?
In another cell enter 10. Copy that cell.
Select A1:A5
Goto EditPasteSpecial
Click Add
OK
Clear the cell with 10 in it.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"Gregorio" wrote in message
...
What I am doing here is this for an example:
Let's Say:
A1 is 4
A2 is 9
A3 is 14
A4 is 56
A5 is 99
And what I want to do is add the number 10 to each one of these numbers in
this column. How would I go about doing this? Is there an equation? I
hope
someone can help...
|