Make all windows (Dialog Boxes) containing variable-sized content resizable
Too many windows force the user scroll well before the comfortable screen space for the window is exhausted. We also do not want these windows to simply be bigger and potentially take up an unnecessary amount of screen space.
For the best of both worlds, I suggest that a window should be resizable if and only if it contains variable-sized content (e.g. scroll bars, text boxes).
Examples of specific windows are listed in the comments.
Peter Bartholomew commented
Full screen would be good. Even then, for a 1000x100 array formula, seeing just the first few rows/columns and the last would be good enough. It is unlikely that I would wish to check all 100,000 values.
Kenneth Barber commented
Examples of specific windows:
• Conditional Formatting Rules Manager
• Unhide Sheet
• Format Cells
• Custom AutoFilter
• Advanced Filter
• Create Table
• Insert Calculated Item
• Insert Calculated Field
• Calculated Item Solve Order
• Expand Field (Analyze tab for PivotTables)
• Protect Sheet
• Insert A SmartArt Graphic
• Data Validation
• Text To Columns
• Create Forecast Sheet
• Excel Add-ins
• COM Add-ins
• Macro (from the View tab)
• Edit Links (https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9087097-make-the-edit-links-dialog-box-resizable)
• Scenario Manager (https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/15952792-make-the-scenario-values-dialog-bigger-and-resizab)
• Evaluate Formula (https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9101269-make-the-evaluate-formula-dialog-resizable)
• Insert Function, Function Arguments (https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13541475-can-we-finally-fix-the-fx-function-helper)
Ben Kirk commented
When creating Scenarios (using the Scenario Manager), the dialog that enables you to enter the values for the scenario is too small.
Yes please!! Trying to check the dependents of a cell (make sure all up to date) but can't see more than the first 20 characters or so - would be nice to be able to resize the window, scroll through and quickly check by eye. (Like the find/replace window)
Nick Gardiner commented
Resize the dialog box so that the information contained within can be viewed.
Manuel Cavero commented
I`ve using AGGREGATTE fuction for the last 2 years, and its impossible to check the function in the actual size
If you click on the little fx at the top, even on the very latest versions of Excel, you get the same tiny, non resizable grey windows xp window with a gigantic list of functions and a search feature that doesn't search anything.
Can you please staff an intern to spend a day fixing it. Use case: think of when you have hundreds of UDF in addition to the hundreds of built-in function, how practical is a 50 pixels high listbox...
John Schram commented
I can't believe this is still an issue. The UI Framework behind Excel is more than capable of making this dialog easily resizable. Microsoft, sometimes it's not about what gets the most votes, it's about how easy something is to fix.
Colin Bowern commented
This dialog feels like nothing has changed since the 1990s. Not sure how much rocket science is involved in making the dialog resizeable but when it comes to evaluating array formulas this would be a gem to have!
Monsieur Le_Nard commented
And this one looks similar as well https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9087097-make-the-edit-links-dialog-box-resizable
Monsieur Le_Nard commented
Couldn't agree more.
This feature request looks similar to https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9101269-make-the-evaluate-formula-dialog-resizable
@MSFT - could you combine the threads to reflect votes appropriately? Thanks.
Kenneth Barber commented
Ingeborg Hawighorst commented
It is hard to work with formulas that reference ranges, like Sumproduct or array formulas, because the dialog shows only four rows. Make it resizable, so we can see more / all of the formula at once.
The current one is way too narrow. I know there is a work around for this where you increasing the size of one or more columns in the box then close it and reopen it but having it resizable like other dialogs would make so much easier.
Bill Bekenn commented
Yes, the Mac version automatically sizes most lists that are displayed to fit the width of the widest item, and as many items as will fit on the screen. This was always so even when early Excel was only available on Mac. When it ported to PC a lot of this was lost and things like the Drop Downs for Data Validation do not show more than a few items often needing scrolling, and they depend on the width of the column not the width of the items in the list. Mac version is still heaps better for dialogue lists.
Levi Bailey commented
And all other dialogue boxes and menus that contain contextual elements for that matter, including Evaluate Formula, Function Arguments, etc