Excel has a useful feature Named Ranges You can name single cells or ranges of cells in Excel Instead of just using the cell link, eg =A1, you can refer to the cell (or range of cell) by using the name (eg =TaxRate) Excel also provides the "Name Manager" which gives you a list of defined names in your current workbookYou can quickly create a named range by using a selection of cells in the worksheet Note Named ranges that are created from selecting cells have a workbooklevel scope Select the range you want to name, including the row or column labels Click Formulas > Create from SelectionA named range is just a humanreadable name for a range of cells in Excel For example, if I name the range A1A100 "data", I can use MAX to get the maximum value with a simple formula =
Naming A Cell Or Range In Excel With Formula Excelnumber