We can name range in excel using selection. For instance, consider the following table with revenue earned in Jan, Feb, Mar, and Apr in columns A, B, C, D, and E, respectively. If we want to create a name range for each column by using the column headers, then we have to select the data range. So, go to the Formulas tab and click on Create from Selection. The Create Names from Selection window appears. Choose the Top Row option. Click OK to create a name range using selection.