R1C1 keyboard shortcut

  • Thread starter Thread starter kemasch
  • Start date Start date
No but you can create a macro to do this. First, paste this code into the
VBA editor (Alt+F11):

Sub ChangeReferenceStyle()
With Application
If (.ReferenceStyle = xlA1) Then
.ReferenceStyle = xlR1C1
End
Else:
.ReferenceStyle = xlA1
End If
End With
End Sub

Then, Tools->Macro->"Macros..." Select the macro, hit "Options" and enter
the shortcut key you would like to toggle this.
 
Nope, but you can have a macro stored in your Personal workbook, and assign
a shortcut to it:

Sub ChangetoR1C1()
Application.ReferenceStyle = xlR1C1
End Sub
 
Back
Top