Enhanced Overview for Formular

[Xarmat]

Hello Excel Forum Members,

Here is my Question:
"Is there a way to get a better overview in Excel formulas?"

Detail:
- I am working in the Game Industry and sometime balancing formulas get large
- Also I have to put new informations in the formulas when the game gets new features
- I need a way to split the content visually to find the right spots where I have to putt more informations in

Idea/wish/best case:
- Managing space via "Strg+Enter" like in Word
- Picture for better understanding: prntscr.com/lofgbc - created with LightShot

Hope someone has an Idea or a tool who can make this.
Or want to build one
I am not sure if the new Excel 2019 version has such a feature.

Thank you for your time, hope there is a solution out there.


Kind Regards
Xarmat

[PaulSP8]

Not sure if it'll help, but one trick I sometimes use on long / nested formulas is using ALT & Enter to move the formula down to another line in the Formula bar

You can then build formulas that look like this;

Please Login or Register  to view this content.

That was done pressing ALT & Enter after each ","

You can ident them using the space bar as well if that helps further?

[Xarmat]

Thank you Paul,

I think this will do it for now.
Hope that Microsoft will add more overview features in the future.

[This thread can be closed]