Tag Archives: Named Ranges

Named Ranges In Excel

Rather than using a cell reference we can use a more descriptive name for a cell or range of cells in Excel.
This can be done using the Name box and/or the Name Manager.
In this way we can make formulas and references easier to understand.

A demo available at www.mathsfiles.com/Excel_Files in the techniques section shows how to do this.

Direct link: Named Ranges Demo