Wednesday, June 19, 2013

How to Revert Excel 2007 to A1 Format Instead of R1C1


1. Click on the Windows 'Start' button and select 'All Programs.' Open the 'Microsoft Office' folder, and then click on 'Microsoft Office Excel' to launch the application.
2. Click on the 'Office' button in the top-left corner of the screen and then click the 'Excel Options' button at the bottom of the menu.
3. Click on the 'Formulas' tab in the 'Excel Options' window. Under the 'Working with Formulas' section, clear the checkbox labeled 'R1C1 Reference Style.'
4. Click the 'OK' button to apply the setting. The change to the cell referencing scheme happens instantly, and you will see the columns are now labeled with a letter rather than a number.

Blogger news