Home |
Search |
Today's Posts |
#1
|
|||
|
|||
R1C1 keyboard shortcut
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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" wrote in message ... 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 |
#4
|
|||
|
|||
Thanks David - works like a charm!!!!! -- kemasch ------------------------------------------------------------------------ kemasch's Profile: http://www.excelforum.com/member.php...o&userid=27785 View this thread: http://www.excelforum.com/showthread...hreadid=472967 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcut for "Paste Values"? | Excel Discussion (Misc queries) | |||
Keyboard Shortcut for moving between Worksheets | Excel Discussion (Misc queries) | |||
Keyboard shortcut to open links | Excel Discussion (Misc queries) | |||
keyboard shortcut | Excel Worksheet Functions | |||
Is there a keyboard shortcut for centering data in Excel? | Excel Discussion (Misc queries) |