For the first issue,

http://www.cpearson.com/excel/ShortCuts.htm
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Wed, 20 Aug 2003 18:30:50 -0400, "Jim Carlock"
wrote:

I have a couple of questions.

1) Anyone have a keystroke reference for Excel. I looked
the help file for a key to automatically convert a cell from a
relative reference to an absolute reference and I all I found
was a reference to using F4 while in edit mode.

2) If there's not a one key press option to convert a cell
from a relative reference to an absolute reference, what's the
best way to create a keyboard macro to do such? When I
tried to create a keyboard macro I'm taken into VBApp
mode. So is there a real method in order to map keys or is
it all done through VBApp mode? And if it's done through
VBApp mode, what's the best way to do this? SendKeys?

Thanks once again to everyone (in advance)!