An absolute reference in spreadsheet software like Excel refers to a cell reference that remains constant even when the formula is copied or moved to another cell. This is achieved by using the dollar sign ($) before the column and row identifiers, ensuring the formula always refers to the specific cell location.