Forum Discussion
excel, filter drop window too small
I use a DELL XPS with 4K monitor and I have the following issue. When I open the drop down window on a filtered column I can see (in addition to rows like sort, filter, text filter and so) only three data rows neverthless there is more space on the sheet. So I have to enlarge the drop Windows but if I close it and reopen again the size still the small one (not the enlarged one). This is very time consuming when I have to use a lot the filters.
12 Replies
- please vote on below:
https://feedbackportal.microsoft.com/feedback/idea/1b815f1d-7f8f-ec11-a81b-000d3a058728 - Waiting for a solution on this since long.
found a solution for width of a combo box but not for filters I have the same issue. Use filter frequently and would like to know how to fix this.
- Same issue for me. Three years later, is it solve?
- Have you tried removing any frozen panes or splits (View tab) to see if that changes it?
- Although I find your list is indeed short, I'm afraid this cannot be changed and neither can you make Excel remember the resize. I suggest you post a suggestion on excel.uservoice.com and get people to vote. At least Excel should remember the size for the current session if you ask me.
