How to Change Columns From Numbers to Letters in Excel 2007

By Nicholas Briano

Microsoft is a spreadsheet program that is part of the Microsoft Office suite of productivity software. In the 2007 version of Microsoft Excel the columns are numbered instead of lettered. If you recently switched from the 2003 to the 2007 version, you may notice this change right away. If you want to switch from the new numbered column system back to the more familiar letter format then you need to change the "R1C1" reference style option.

Step 1

Open Microsoft Excel 2007 to open a blank worksheet. Locate the 'Office' button in the top left hand corner next to the exit button. Click on the 'Office' button.

Step 2

Click on "Excel Options." A new menu window will appear in which you need to click on the "Formulas" tab.

Step 3

Deselect he "R1C1 Reference Style" check box. Click "OK"to close the window and save your selections. This will change the columns from numbered to lettered immediately. To change the R1C1 reference style again simply revisit the excel options again and check the R1C1 box.

Tips & Warnings

  • For MAC operating systems. Open Excel and click on the "Excel" menu option in the top left corner. Select "Preferences" followed by the "General" heading. This is where you can change the R1C1 style.