ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I add the same value to values in every row of a column in. (https://www.excelbanter.com/excel-discussion-misc-queries/19127-how-do-i-add-same-value-values-every-row-column.html)

Jamie

How do I add the same value to values in every row of a column in.
 
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.

Niek Otten

Hi Jamie,

In an empty cell, enter the number 50. EditCopy

Select the cells you want to add 50 to.

EditPaste Special, check Add.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Jamie" wrote in message
...
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.





All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com