SHIFT-ENTER Gives You a Line Break In Your Formulas, Makes Them More Readable!
For a long time now I have used Notepad to edit my more complex Power Pivot formulas. In Power Pivot v1, if you hit <SHIFT>-<ENTER> while editing a formula, that was the same as clicking OK, so we had to use a different editor and then copy/paste the formula over.
At some point MS quietly fixed that and I didn’t notice. One of my students recently discovered it.
Now you can have line breaks AND still enjoy the benefits of autocomplete. Have fun