In spreadsheet applications, the absolute address of a cell is represented by prefixing both the column letter and row number with a dollar sign ($). So, the absolute address of cell G5 is represented as $G$5. This means that if the formula is copied to another cell, the cell reference will not change.