Cell Addressing in Spreadsheet
A cell address in Excel refers to the unique identifier of a cell within a worksheet.
It specifies the location of a cell based on its column and row position.
Cell addresses are represented by a combination of letters and numbers. The letters represent the column and the numbers represent the row.
For example, in the cell address "A1"
"A" refers to the column header.
"1" refers to the row number.
Together, "A1" identifies the cell located at the intersection of column A and row 1.
To summarize:
Relative referencing adjusts the cell references based on the formula's position.
Absolute referencing keeps the cell references constant, irrespective of the formula's position.
Please refer to my blog for details.