How to Name a Column in Excel 2007


The name box in Excel 2007 can reference individual cells, a range of cells and columns. You can use names to describe a cell or column in a formula or table. It's best to use a distinct name you haven't used elsewhere in your worksheet when you name a column. Alternatively, you can use R1C1 reference styles to name columns. R1C1 reference styles change the names of columns from letters to numbers, so formulas refer to them differently.

Using Name Box

  • Click the column heading, such as "A," "B" or "C," to select the column you want to name in Excel 2007.

  • Go to the "Name Box" just above column A.

  • 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

  • Click the Customize Quick Access Toolbar button and select "More Commands" in Excel 2007.

  • Select the "Formulas" tab in the Excel Options window.

  • Check "R1C1 reference style" under the "Working with formulas" section. Click "OK."

Related Searches


  • Photo Credit Stockbyte/Stockbyte/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!