Complete guide to Excel 2016 (Part 15): Relative and absolute reference cells
there are two types of cell references: relative (relative) and absolute (absolute). relative and absolute references work differently when copying and filling in different fields.