How to Name a Column in Excel 2007

Using Name Box
1. Click the column heading, such as 'A,' 'B' or 'C,' to select the column you want to name in Excel 2007.
2. Go to the 'Name Box' just above column A.
3. Type the column's name into the box and press 'Enter.' The column's name displays when you select the column header.
Using R1C1 Reference Style
4. Click the Customize Quick Access Toolbar button and select 'More Commands' in Excel 2007.
5. Select the 'Formulas' tab in the Excel Options window.
6. Check 'R1C1 reference style' under the 'Working with formulas' section. Click 'OK.'