G Guest Dec 9, 2006 #1 I want to use CTRL+Z to pull up Insert Function Dialog window.. People its a challenge to me Plzzzzzzzzzzzzzzzzzzz Help
I want to use CTRL+Z to pull up Insert Function Dialog window.. People its a challenge to me Plzzzzzzzzzzzzzzzzzzz Help
D David McRitchie Dec 9, 2006 #2 Ctrl+Z is undo, that would be a very bad choice see shortcuts http://www.mvps.org/dmcritchie/excel/shortx2k.htm Alt+I+F does what you want You can install the following macro to bring up the Function Wizard to install see http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro Sub FxWizard() Application.Dialogs(xlDialogFunctionWizard).Show End sub To assign your own shortcut key to a macro see http://www.mvps.org/dmcritchie/excel/shortx2k.htm#mykeys
Ctrl+Z is undo, that would be a very bad choice see shortcuts http://www.mvps.org/dmcritchie/excel/shortx2k.htm Alt+I+F does what you want You can install the following macro to bring up the Function Wizard to install see http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro Sub FxWizard() Application.Dialogs(xlDialogFunctionWizard).Show End sub To assign your own shortcut key to a macro see http://www.mvps.org/dmcritchie/excel/shortx2k.htm#mykeys
