By doing this, the reference will point back to the same cell, regardless of its appearance in the workbook. However, if you need your cell reference to stay the same when it’s moved, copied, or filled, you’ll want to use an absolute cell reference. This is useful when you’re performing the same calculation in each row or column. When relative cell references are copied to more than one row or column, they change depending on their position.
Cell references refer to data from two or more contiguous cells on the worksheet, data contained in different areas of a worksheet, or data on other worksheets in the same workbook. In an Excel spreadsheet, a cell reference is a cell or range of cells that can be used in a formula.
