View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default How do I add the same number/value for an entire column in Excel?

Enter the number 10 into any blank cell
Copy that cell
Select your range of data
Paste Special
Check the box for "Add"
Click OK
Delete the 10 that you entered originally

10 has now been added to all of your data.

HTH,
Elkar


"Gregorio" wrote:

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...