Here’s a tip from Charles Kyd. Press Control+Shift+A after you’ve typed the first parenthesis of a function and Excel fills in the argument names.
Type the function name and the open parenthesis:
Press Control+Shift+A to see the arguments:
Since I use Excel 2000 for almost all of my development (and it doesn’t have that handy function intellisense), this shortcut has come in handy for those lesser used functions. Similarly, Control+A pressed at that time will open the function wizard, a feature I seldom use.
Just when I think I know every keyboard shortcut, I learn another one. Thanks Charles.