The absolute address of the last cell of the cell range B4: F9 in an MS-Excel worksheet is $F$9. Important Points When someone wants a formula to consistently refer to a particular cell, even if he/she copy or move the formula elsewhere on the worksheet, the user needs to use an absolute cell reference. An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both. When a user enters a cell reference in a formula, Excel assumes it is a relative reference unless he/she change it to an absolute reference. If the user wants part of a formula to remain a relative reference, remove the dollar sign that appears before the column letter or row number.