How to Change Columns From Numbers to Letters in Excel 2007

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

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

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

Step

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.