A relative cell reference inform Excel to fix the cell reference as it copies it to the designated area. You can press the correct range in a function by typing the beginning and entering cell references divided by a colon (:) The adjusted cell references in a copied and paste formula are called relative references.