1

Can one help me to make a short key for the following procedure in Excel 2010 (ALT+DownArrow then E) . this used to go directly to search box in filter excel like shown in photo

enter image description here

and if some know another way to jump directly to this window of filter it is really will increase the speed of my work while searching

thank you very much

Improve this question
10
  • What research have you done and what have you tried in order to accomplish this? Commented Apr 1, 2015 at 11:28
  • just need a short key to jump directly to searching box in sort&filter function . like while I stand on a top cell to search I should press ALT+ArrowDown than press E , I just want a short key to collect this operation Commented Apr 1, 2015 at 12:04
  • It is obvious what you WANT. My comment is asking what you have done on your own to figure this out. I'm not trying to be difficult, rather want you to understand we volunteer out time here to help when you get stuck attempting to do something, not to just do it for you. There is additional information available in the help center. Commented Apr 1, 2015 at 12:44
  • Have you tried recording a macro and assigning it a shortcut key? Commented Apr 1, 2015 at 12:45
  • yes I tried but the macro not help.. if u can do it Commented Apr 1, 2015 at 12:55

1 Answer 1

Reset to default
1

You can get this behavior with just a single mouse click. Include the following event macro in the worksheet code area:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
    Application.EnableEvents = False
        Application.SendKeys "%{DOWN}f"
    Application.EnableEvents = True
End Sub

Anytime you click on cell A1, the pull-down will occur automatically.

Because it is worksheet code, it is very easy to install and automatic to use:

  1. right-click the tab name near the bottom of the Excel window
  2. select View Code - this brings up a VBE window
  3. paste the stuff in and close the VBE window

If you have any concerns, first try it on a trial worksheet.

If you save the workbook, the macro will be saved with it. If you are using a version of Excel later then 2003, you must save the file as .xlsm rather than .xlsx

To remove the macro:

  1. bring up the VBE windows as above
  2. clear the code out
  3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

and

http://msdn.microsoft.com/en-us/library/ee814735(v=office.14).aspx

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm

Macros must be enabled for this to work!

Improve this answer
4
  • thank you it is really good but not worked 100% because it need to leave the cell and press back to activate and not jump to search box directly , I am really will appreciate that if u can update your code to be better.. and another thing this code can't be shortkey in Macro? Commented Apr 2, 2015 at 7:55
  • WOW I fixed the jumping to search box I just changed the "%{DOWN}f" to "%{DOWN}e"... but still trying to activate when I remain on same cell :( Commented Apr 2, 2015 at 8:02
  • @Monther Sadly.................the macro needs you to leave the cell and then re-enter it. Commented Apr 2, 2015 at 11:00
  • Thank you Gary you teach me more things in your answer really thanks Commented Apr 2, 2015 at 11:15

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.