Change Column Headers From Numbers to Letters

August 15th, 2004 | Categories: General | Tags:
-->

Or change column headers from letters to numbers. Old school spreadsheets used numbers for rows and column headers, excel calls this old method R1C1 reference style. Here is how to toggle between the two.

On the main menu
1. Click Tools
2. Click Options
3. Select the General Tab
4. Place or remove a check next to the “R1C1 Reference Style” option to suit your liking and hit OK.

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
  1. Ron
    August 4th, 2008 at 02:42
    Reply | Quote | #1

    Great tip, couldn’t find it in excel help.

  2. January 28th, 2009 at 11:02
    Reply | Quote | #2

    wow. this helped with my IT coursework.