Thursday, July 26, 2012

How to Change to R1C1 Cell Reference in Excel 2007


1. Open Microsoft Excel 2007.
2. Click on the 'Office' button in Excel.
3. Click on 'Excel Options.'
4. Click on 'Formulas,' in the left-hand pane of the 'Excel Options' box.
5. Check the 'R1C1 reference style' check box under 'Working with formulas' to enable 'R1C1' style referencing. Clear this check box to use 'A1' style referencing.

Blogger news