Workbook Click the letter of the column you want to change and then click the "Formulas" tab. Click "Define Name" in the Defined Names group in the Ribbon to open the New Name window.

2. From the Formulas tab, click Define Name. 3. Notice that Excel has already entered the column/field name of the range you highlighted (even though that cell was not included in your range).