[Solved] Combining data in columns

[banjobiotic]

Hello and please forgive my ignorance. I am trying combine the data in columns B through G in my calc file. Reading the forums here I have gotten as far as this formula =B2&" "&C2&" "&D2&" "&E2&" "&F2&" "&G2. What I can't get past is how to use that formula to get all the rows combined. If I paste that formula into the H3 for example I just get the data from row 2. How do I get the formula copied into all rows and auto adjust for the different row numbers? Please be as detailed as possible with your answers and assume I really don't know what I'm doing. Thanks!

[FJCC]

There are several ways to do this. One of them starts by clicking on the cell that contains the formula. It will then be surrounded by a black border and in the lower right corner there will be a small black square. Click and hold on that square and drag it down as far as you want the formula to be copied. As the formula is copied down the row reference will be automatically increased.

[robleyd]

You may find [Tutorial] Absolute, relative and mixed references a useful reference.

[banjobiotic]

There are several ways to do this. One of them starts by clicking on the cell that contains the formula. It will then be surrounded by a black border and in the lower right corner there will be a small black square. Click and hold on that square and drag it down as far as you want the formula to be copied. As the formula is copied down the row reference will be automatically increased.

That was what I needed! Thank you!