How do I change the cell dispay in Excel 2007 from C1:R2 to A2

B

Bob Umlas, Excel MVP

Office button/Excel options/Formulas/ 2nd section has "R1C1 reference style"
turn it on/off here
 
Top