[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 559
  • Last Modified:

Modify default height of drop-down filter menu in Excel

Hello,

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).

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).

Fig 2Fig 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?

Thanks
0
WeThotUWasAToad
Asked:
WeThotUWasAToad
1 Solution
 
D PatelD Patel, Software EngineerCommented:
No, There is no way to change height (length) of the Auto-Filter Popup.
0
 
Glenn RayExcel VBA DeveloperCommented:
No points, but I agree with @D Patel; it can't be adjusted in height.
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now