i want to add the same value to all values in a particular column in microsoft execl please help?

Question

dear hook , justin and the humble one by here I mean mathematical addition.as for the methoed of inserting a new column,applying formula and then deleting the original or copying new values to original it dosent work . as modifying the original column means changing whats being reffered to in the formula and hence causes an error. all cells get filled with REFF#

Answer 1

Column A has your numbers.
Let's say the number you want to add to all of the numbers in Column A is 77.

Cell B1, put in value "=a1+77" w/out the quotes.

Copy contents of cell B1 to the remainder of the B column cells that have a corresponding value in the A row. It will automatically bump the A row value.

A...............B.......Result
1..........=a1+77..........78
2..........=a2+77..........79
3..........=a3+77..........80

Answer 2

You currently have a column with different values in the cells, and you want to add the same value to each of them. Since they're all different to start with, you can't use the autofill. Here's what I would try:
don't try to do it in the cell itself -- use the next column over (insert a column if you need to. Let's say the current values are in col A (starting at row 1), so we'll use col B for our results (also starting at row 1). Click B1 cell, and type this formula:
=A1+[the value you want to add]
and press Enter. (don't use the brackets, in the formula, just type the number you want to add)
Now click B1 again, and this time use the autofill: position mouse over bottom right corner of that cell to get autofill tool, and click and drag down through all the empty cells below in the B column, and the cells will each fill in with the amount in the corresponding A column, plus the value you added.

Answer 3

Copy the cell with the value. Click the column letter (this will highlight the entire column). Paste.

Answer 4

Select the cell. Click in the bottom left and corner of the cell and drag to to bottom of that column. Ask again for any more help if this doesn't work.

Answer 5

Justin K is correct, however, this will also copy that value to the heading of that column. Just re-enter it.

Answer 6

It is very simple. Place cursor on the right hand corner (on the square) of the cell that you wanted copied and drag it down to the last cell that you want copied.

Answer 7

try the getting the answer from Miscrosoft's Web site for OFFICE....or eventry to copy the formula/value to the other cells