Google Sheets pretty formulas formatting

You can press:

Ctrl + Enter on Windows

⌘ + Enter on a Mac

inside the formula editor bar to add new lines to your formulas in order to make them more readable.

To comment inside formulas, you can use N().

For example:

=SUM(A1:A)+N("This is a comment.")

this will give exactly the same result as:

=SUM(A1:A)

Note that:

N("This is a comment") 

returns 0.

If you want to avoid that, you can use T(N("comment")) which acts like a blank string.

Example:

Probably not the best answer, but as I had the same problem before, what I do is copy the formula to a text editor (or pastebin), ident the formula, select all and then repaste in the google sheets formula. If pasted it will have a line break, like this:

={
ARRAYFORMULA(somecomplicatedstuffhere) ,
ARRAYFORMULA(moreformulashere) 
}

Also, if you are inside the cell, you can add a newline this way:

• Windows: Ctrl + Enter
• Mac/ Linux: ⌘ + Option + Enter