Auto resizing of formula bar
Give us an easily accessible option to have the formula bar resize automatically if a formula spans across multiple rows in the formula bar so the whole formula will be visible.
Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.
John [MS XL]
I absolutely agree with the need for multi-line formulas in Excel. The enhanced readability that provides is one of the major reasons we've added multi-line formulas (as well as no-code app & BI dashboard creation and real-time collaborative editing) for Excel (as well as web & mobile) with our free Power Sheet platform (https://PowerSheet.ai).
As a workaround, for those, who prefer to be able to see and edit all column definitions at the same time, we've provided that for Excel with Columns & Formulas editor, which allows you to see multi-line formulas for all columns at the same time, along with Smart Field Type (Multi-Select, Date Picker, Assignment, Tags, Drop-down, Slider, File Attachment, etc.) and other options (Auto Lookup Relationship, default or initial value, etc.).
Jaime Segura commented
I think it would be great if it could have it's own type font and size so one can choose a monospaced one (helps a lot when building complex formulas). Also a "formatter" like on daxformat or Excelbeautifier would be useful!
Andrew Moss commented
I like this idea, but it would be even better if the formula bar could pop out into a separate window. Some of my formulas are so long I have to drag the formula bar to the bottom of my screen, therefore not leaving any room for the worksheet to be displayed.
Sergei Baklan commented
I voted since that's better than nothing. But I definitely would like to have an option to switch on/switch off such expanding. In general that's much better to have separate formatter or Advance Editor, more they are integrated into Excel the better.
Wyn Hopkins commented
I definitely want it to expand automatically while typing or editing. I’m thinking that just selecting a cell with a multi row formula would cause an indicator (expand icon) to appear next to formula bar
Microsoft Excel Recalc or Die commented
Great suggestion! just in case, today it is possible with this keyboard shortcut: CTRL + SHIFT + U.
Wyn Hopkins commented
This becomes even more important now that the LET function is being introduced
It'll be useful if on can manipulate the font of the formula bar (without having to change default font of the application)... is so useful to write formulas with monospaced fonts.
An auto format (like DAX formatter) would be also a great option.
Gary Rosner commented
While you are at it, how about a Zoom function to make the fonts in the formula bar larger. On 4K monitors, you need dentist glasses to see the tiny fonts in the formula bar.
What about allowing us to create multi-line formulas like in DAX (PowerPivot) with tabs and comments? Excel formulas are still a nightmare to troubleshoot.
Or at least make it visually obvious that a formula has more than what can be seen in the formula bar. When the formula bar wraps, perhaps a tooltip could appear that says "See more".
John [MS XL]
I posted an idea to change the formula bar colour, which I think is what Col Delane is referring to:
The intention of my idea was to ensure users don't overlook parts of the formula that can't be seen, which I think is the intention of this idea as well. So you might want to merge my idea into this one.
I came to this Excel.UserVoice.com site to make this EXACT suggestion. Thank you for submitting it and I vote YES!!
Col - can you post a link to the request/idea that you are referring to? I haven't seen a duplicate of this one.
Col Delane commented
An existing suggestion covers this topic