I need to clarify something. The sentence "It does not matter what
you do in terms of coding absolute or relative references in the
formulas" is absolutely false; absolute references will be
maintained. But to get the same relative references in every cell you
do have to Select each one individually.