Does a keyboard shortcut exist to toggle the R1C1 function?
Does a keyboard shortcut exist to toggle the R1C1 function?
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.
--
Regards,
Dave
"kemasch" wrote:
>
> Does a keyboard shortcut exist to toggle the R1C1 function?
>
>
> --
> kemasch
> ------------------------------------------------------------------------
> kemasch's Profile: http://www.excelforum.com/member.php...o&userid=27785
> View this thread: http://www.excelforum.com/showthread...hreadid=472967
>
>
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
--
Regards,
Juan Pablo González
Excel MVP
"kemasch" <[email protected]> wrote in
message news:[email protected]...
>
> Does a keyboard shortcut exist to toggle the R1C1 function?
>
>
> --
> kemasch
> ------------------------------------------------------------------------
> kemasch's Profile:
> http://www.excelforum.com/member.php...o&userid=27785
> View this thread: http://www.excelforum.com/showthread...hreadid=472967
>
Thanks David - works like a charm!!!!!
Thank you.
Works Like a charm! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks