Sunday, May 12, 2013

How to Change Columns From Numbers to Letters in Excel 2007


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.
2. Click on 'Excel Options.' A new menu window will appear in which you need to click on the 'Formulas' tab.
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.

Blogger news