Is there a way to modify the default height of the drop-down menu boxes when using filters in Excel?
The default drop-down menus when filtering in Excel are so small that, without scrolling, only 3-4 options are visible (Fig 1).
Not long ago I noticed that the size of the box can be increased by dragging the bottom-right corner (Fig 2 & 3).
Now I'm wondering if there is a way to increase the default size of the boxes — either with a setting somewhere or by using VBA.
Is that possible?