Strategies to display formula in a more organised way when editing?

[appreciatethehelp]

I’ve noticed that as I use longer, nested formulae, I tend to get a little lost when editing, as the beginning of each nested function occurs at an abitrary point in the cell, depending on how long the function is i.e. each nested function doesn’t start at the beginning of each line when viewing the formula within the cell itself.
I realise I can view the formula using the menu bar above, however this poses a different issue, as the formula is largely obscured by its small size.
Due to these two “issues”, I sometimes find it difficult to read/conceptualise the way a formula works in its entirety, particularly when many functions are nested.

This got me thinking: what are some strategies the more experienced users here employ to assist with improving the layout of formula in order to edit it more easily?
Something I was doing for awhile was copy/pasting the formula into Writer, then separating each function into its own line, editing it, then copy/pasting it back into Calc. This does work, but I’m wondering if there’s a faster/easier method?

[mikekaganski]

Is there and easy way to handle long formulas?

I write a formula in a cell. Then I have to modify it in the address bar. And quite often it is growing longer and longer, more complicated. I get hassles with the editor in the address bar sometimes. The whole thing is not too user friendly. Is there a better way to handle building and putting long formulas into your spreadsheets?

[erAck]

Note also that you can expand the Formula Bar vertically by clicking the arrow on its right to have a multi-line edit field. This also allows to structure the formula visually by inserting line feeds with Ctrl+Enter. However, the line feeds are not preserved once the formula is accepted with Enter. (there’s tdf#76310 for that).

[LeroyG]

Also you can expand the Imput line dragging down the line that separate it from the column headings.