You can set up a Macro:

Sub relative()

With Application
.ReferenceStyle = xlR1C1
End With

End Sub

Sub absolute()

With Application
.ReferenceStyle = xlA1
End With

End Sub

and just assign keyboard shortcuts to it


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=550367