Formatting cells using formulas

Question

I'm using Excel 2016 as a spreadsheet to track my profits/loss. For some reason one of my columns is off from where it should be. What is the formula to add an amount to one cell to make the next cell 500 higher? Example is add $500 to column L so that column M = L+$500

Answer 1

Hi Patrick, to enter that formula into a whole column:

Click the column Header

Type =L1+500

Then press Ctrl + Enter

That will fill that whole column for you with the appropriate formula . . .

Answer 2

You would need to do it to each cell in the column that you want that result in. You can enter it in one cell and then copy and paste, or click the AutoFill handle in the bottom right corner of the cell and drag up or down the column.

Answer 3

Would I have to do this for each individual cell? or can I do it for the whole column?

Answer 4

You would put the formula in a cell in column M. For example, if you want cell M2 to be $500 more than cell L2, enter this formula in cell M2:

=L2+500