Change Column Headers From Numbers to Letters

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.

Leave a Comment