Excel’s Name box is a powerful tool for an ordinary dropdown. To find it, look to the left of the Formula bar. Usually, it displays the reference for the current cell as shown in Figure A.

How to Give a Name to the Columns in Excel. ... You can apply column names to a single worksheet or increase the scope and apply it to an ... Enter the new name of the column in the Name text box.