HaydenJalili
New Member
- Joined
- Aug 27, 2020
- Messages
- 3
- Office Version
- 2010
- Platform
- Windows
I use the little filter arrows a lot in excel 2007 and they are cool because of all the extra options and because it lists all your data with a check box so you can select many many variable - it's great - and I know I can change the size of the box all those choices are in by just grabbing the size handle at the bottom right corner and pulling it.
I am CONSTANTLY grabbing that handle and pulling down so I can see more of the filter list in one view - it really helps with scrolling long lists:
Is there a way to change the default size so it is bigger or am I required to grab that little handle all the time? (I'm a keyboard type - speed!)
There must be a VB code object parameter buried in there somewhere that tells the box how big to be when you activate the down arrow? Anyone know how to get to it and can I change the default size of perhaps change it's behavior to autosize or somthing?
Thanks for the help
I am CONSTANTLY grabbing that handle and pulling down so I can see more of the filter list in one view - it really helps with scrolling long lists:
Is there a way to change the default size so it is bigger or am I required to grab that little handle all the time? (I'm a keyboard type - speed!)
There must be a VB code object parameter buried in there somewhere that tells the box how big to be when you activate the down arrow? Anyone know how to get to it and can I change the default size of perhaps change it's behavior to autosize or somthing?
Thanks for the help