excel, filter drop window too small

%3CLINGO-SUB%20id%3D%22lingo-sub-136724%22%20slang%3D%22en-US%22%3Eexcel%2C%20filter%20drop%20window%20too%20small%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-136724%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20a%20DELL%20XPS%20with%204K%20monitor%20and%20I%20have%20the%20following%20issue.%20When%20I%20open%20the%20drop%20down%20window%20on%20a%20filtered%20column%20I%20can%20see%20(in%20addition%20to%20rows%20like%20sort%2C%20filter%2C%20text%20filter%20and%20so)%20only%20three%26nbsp%3Bdata%20rows%20neverthless%20there%20is%20more%20space%20on%20the%20sheet.%20So%20I%20have%20to%20enlarge%20the%20drop%20Windows%20but%20if%20I%20close%20it%20and%20reopen%20again%20the%20size%20still%20the%20small%20one%20(not%20the%20enlarged%20one).%20This%20is%20very%20time%20consuming%20when%20I%20have%20to%20use%20a%20lot%20the%20filters.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-136724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147658%22%20slang%3D%22en-US%22%3ERe%3A%20excel%2C%20filter%20drop%20window%20too%20small%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147658%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20issue.%20Use%20filter%20frequently%20and%20would%20like%20to%20know%20how%20to%20fix%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-137208%22%20slang%3D%22en-US%22%3ERe%3A%20excel%2C%20filter%20drop%20window%20too%20small%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-137208%22%20slang%3D%22en-US%22%3EAlthough%20I%20find%20your%20list%20is%20indeed%20short%2C%20I'm%20afraid%20this%20cannot%20be%20changed%20and%20neither%20can%20you%20make%20Excel%20remember%20the%20resize.%20I%20suggest%20you%20post%20a%20suggestion%20on%20excel.uservoice.com%20and%20get%20people%20to%20vote.%20At%20least%20Excel%20should%20remember%20the%20size%20for%20the%20current%20session%20if%20you%20ask%20me.%3C%2FLINGO-BODY%3E
Occasional Visitor

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. 

 

 

 

10 Replies
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.

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?
No i have the same issue as a lot of Excel workers with filters; If your column is smaller than the numbers of character's you want too see, everytime you have to enlarge it in the down right corner of the display window instead of having an autoadjustment display with the larger field of the list until you change that display window to your convenience.

Create a screen-shot of your issue, paste that screen-shot in an empty Excel file. Then click File, Feedback, I don't like something and explain your issue and check the screen-shot box. If everyone with this problem does so, it'll get their attention.

Thanks, I did it. Is there a way to paste my snapshot into the answering box? its not working.
No, the snapshot box always takes a shot of the current window, so you best paste the snapshot on that window prior to clicking the feedback button, as I wrote above.

At least, it should look at this :

Biz1961_0-1628779458301.png

 

 

@Biz1961