How to keep certain values constant in a formula

[swoodall]

Here is my formula:

=C2&" "&D1&" "&D2&" "&E1&" "&E2&" "&F1&" "&F2&" "&A1&" "&A2

Of course when I drag and copy the formula down it increases the values of each cell by 1. I need cells D1, E1, F1 and A1 to stay the same as I copy the formula down and the remaining cells to increase by 1. Is this possible? If so, how. If not, what is an alternate method?

 

[MrKowz]

Make them absolute references by adding $ signs:

=C2&" "&$D$1&" "&D2&" "&$E$1&" "&E2&" "&$F$1&" "&F2&" "&$A$1&" "&A2

 

[swoodall]

thank you so much.