Tip: Format Excel formulas

I don’t know why this never dawned on me, but you can do some rudimentary formatting in the Excel fromula bar. Alt+Enter makes a new line.

I’ve known this for decades for displayed text (hence the “Wrap Text” option), but I never cared what an unseen formula looked like. But why not make it readable?

4 Likes

Are you allowed in there? That looks an awful lot like code!

8 Likes

I was waiting for that

1 Like

His profile says low-coder, not no-coder.

Oh he knows. It’s just flak. I’ll probably give @Banderson the “solution.”

1 Like

1 Like