How to Convert New Excel From R1C1 to A1

1. Double-click the Excel file you want to work with to open it using Excel 2010.
2. Click the 'File' tab at the top of the Excel ribbon, then click 'Options' from the bottom of the list on the left side of the screen. The Excel Options window appears.
3. Select 'Formulas' from the list on the left side of the window, then look for the 'Working with formulas' area on the right side of the window. Click the check next to 'R1C1 reference style' to remove the check.
4. Click 'OK' to close the Excel Options window. Your spreadsheet now uses the A1 reference style and Excel automatically changes all the current references to the A1 style.