In spreadsheet, an absolute cell reference is represented by using the dollar sign ($) before the column letter and row number. This helps to fix the reference to a specific cell when copying the formula to other cells.