If you wish to keep the original cell reference when you duplicate it, you can “lock” it by adding a dollar sign ($) before the cell and column references. For example, if you duplicate the formula =$A$2+$B$2 from C2 to D2, the formula remains unchanged. This is a definitive reference.