Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 692
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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