Q. How do I toggle between A1 and R1C1 addressing modes?
A. (excel 2007) Magic circle -> Excel Options (at bottom) -> Formulas -> R1C1 checkbox [ info from here ]