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.

The data includes the following details for each customer: Customer ID, Name, Email ... Tip: To quickly select visible cells only in Excel, select the range of cells you want to copy and press ...