Relative, absolute and mixed cell referencesĪ cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet.įor example, A1 refers to the cell at the intersection of column A and row 1 B2 refers to the second cell in column B, and so on.How to change a cell address in a formula.How is a cell address defined in Excel? What is an absolute and relative reference and when each should be used? How to cross reference between different worksheets and files? In this tutorial, you will find answers to these and many more questions. The tutorial explains what a cell address is, how to make absolute and relative references in Excel, how to reference a cell in another sheet, and more.Īs simple as it seems, Excel cell reference confuses many users.
