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.