Cap Book Question Alright guys your going to have to bear with me for a while on this, as I have not had much experience using spreadsheets. I got a question that maybe Jeremy could answer for me. It regards the formula that determines each players salary. Say I add a new player in row 2 and I just want to copy the salary formula from player in row 1 and paste in row 2, is there a way I can change all C1's in the formula to C2's all at once instead of changing each C1 in the formula. Does that make sense?