> Write simpler formulas.
Excel's formula language seems deliberately designed to prevent that.
Re:The Tyranny of Spreadsheets
by quietbritishjim on Friday July 23, 2021 @12:17PM
(#27932402)
They mean simpler formula per cell, by splitting the formula across multiple cells (as I mentioned in my sibling comment).
In fact, people who are aware of Alt-enter produce buggier code: they end up writing longer formulas, with fewer intermediate results displayed, and have less visibility of the functioning of their spreadsheets.
Write simpler formulas.