By beaking a formula, I mean writing a formula in multiple rows, instead of one.
Usually, when we write some text, we use Enter to move to the new lines. In Excel, it doesn’t work that way. If you press Enter, the formula will be executed.
To break a formula into multiple smaller chunks, you have to perform these steps:
- Click a cell and start typing a formula.
- If you want to continue the formula in a new line, press Alt + Enter.
- Continue typing the formula.
- Press Enter to finish, or Alt + Enter to continue.
If you want to edit such a formula, you can double-click it, or press F2 and use keyboard arrows to move inside the same way as with one-line formulas, but this time in two directions.