How To Use Absolute Relative and Mixed Cell References in Excel

Cell Reference in Excel can be considered as an address of the cell. To access the content of any cell during programming or writing formulas or creating charts, we need to know its address. Cell Reference in Excel is denoted by two letters, where first letter denotes the Column and second letter denotes the Row. For instance, A1 stands for first column and first row, A2 stands for first column and second row and so on. Now what makes a cell reference absolute, relative or mixed is usage of the $ symbol. Let’s understand each one of these by taking example. Continue reading