Hi, my office is using excel 2010 if I'm not wrong and I am often required to filter for ID numbers.
Hence, I'd like to actually create a shortcut such that the "filter - equal to" window will immediately open.
I've tried creating a shortcut, however most of the times it forces me to enter a value in the equal to button. What I'm hoping is just have the window pop up for me to key in the values.
For example when you press ctrl + o, the open tab opens.
Thank you so much for your help!
Hence, I'd like to actually create a shortcut such that the "filter - equal to" window will immediately open.
I've tried creating a shortcut, however most of the times it forces me to enter a value in the equal to button. What I'm hoping is just have the window pop up for me to key in the values.
For example when you press ctrl + o, the open tab opens.
Thank you so much for your help!
