View Full Version : Solved: R1C1 AND Letters - is there a way to see both

02-20-2009, 11:11 AM
Hello All. I'm in Excel 2007, and find my self going back and forth between R1C1 display and letters for Columns constantly. Wondered if anyone knew a way to display both, or alternately a shortcut instead of going to the Office button, Excel options, Formulas etc. Am I crazy or would anyone else find this helpful? Thanks in advance.


02-20-2009, 12:35 PM
Just write a simple macro

Sub ToggleReferenceStyle()

With Application

.ReferenceStyle = IIf(.ReferenceStyle = xlR1C1, xlA1, xlR1C1)
End With
End Sub

add a button to the QAT and assign it to that button

02-20-2009, 12:44 PM
Thanks for making my Friday. Worked like a charm. You rock.