Solved

Modify default height of drop-down filter menu in Excel

Posted on 2016-10-12
2
57 Views
Last Modified: 2016-10-23
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
Comment
Question by:WeThotUWasAToad
2 Comments
 
LVL 6

Accepted Solution

by:
DPatel earned 500 total points
ID: 41841363
No, There is no way to change height (length) of the Auto-Filter Popup.
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 41844457
No points, but I agree with @D Patel; it can't be adjusted in height.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
locking multiple column ranges 10 25
Excel format formula for currency 15 24
And OR formula 5 22
Excel file that does not ask to be saved before exiting 6 23
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question