How to Name a Range in Excel Naming a cell or a range of cells in Excel is straightforward. Simply select the cell or range you want to name, and replace the cell reference with the desired name ...

Where <prefix> is the prefix to be added and <cell number of first cell> is the location of the first cell in the column to which to add the prefix. Eg. We are creating the list in column C.