View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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...