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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Find values across a row and return a text value from the same column 2
insert row when sum of values equals 100 3
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Add columns to reach a predetermined value 2
Count of Different Columns 5
how do I calculate the sum of hours if marked x in a schedule? 2

Back
Top