ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shortcut Key --- A Challenge (https://www.excelbanter.com/excel-discussion-misc-queries/122047-shortcut-key-challenge.html)

Deepak

Shortcut Key --- A Challenge
 
I want to use CTRL+Z to pull up Insert Function Dialog window..


People its a challenge to me
Plzzzzzzzzzzzzzzzzzzz Help

David McRitchie

Shortcut Key --- A Challenge
 
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....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...x2k.htm#mykeys


---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"Deepak" wrote in message ...
I want to use CTRL+Z to pull up Insert Function Dialog window..


People its a challenge to me
Plzzzzzzzzzzzzzzzzzzz Help





All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com