How do I add the same value to values in every row of a column in.

J

Jamie

I have a list of numbers, and want to add 50 to each one. The numbers are
all in the same column. I just want to add 50 to each row. Please let me
know how to do this. Which formula to use.
 
N

Niek Otten

Hi Jamie,

In an empty cell, enter the number 50. Edit>Copy

Select the cells you want to add 50 to.

Edit>Paste Special, check Add.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top