A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address. ... A reference that identifies a cell's location in the worksheet based on its row number and column letter.
