Formulas and functions are usually created using references to other cells on the spreadsheet. Where you need to refer to a fixed cell and still be able to duplicate the formula around the spreadsheet then you can use fixed cell references as explained in the Simple Formulas and Functions reference guide. These absolute and mixed … Continue reading Named Cells, Ranges and Values