3 ms·

If you have a long expression, you can break it into multiple ones by storing some intermediate results in another cell. You can also hide such cells or put the

by xiaq 6y ago

If you have a long expression, you can break it into multiple ones by storing some intermediate results in another cell. You can also hide such cells or put them in another sheet. This might sound like a hack, but being able to see intermediate results makes debugging complex expressions easier too, so in a sense it is working as intended.

darkerside 6y ago
3D Excel would be intriguing. A dimension on which to store intermediate calculations.
- phonon 6y ago
  Sounds like https://en.wikipedia.org/wiki/Lotus_Improv https://en.wikipedia.org/wiki/Lotus_Improv
- davchana 6y ago
  I would love just getting the ability to resize the Evaluate Formula dialogue box text area.
DavidPeiffer 6y ago
Formula -> Trace Dependencies/Precedents is also super handy! I have a short VBA loop that applies it to all selected cells. It makes it very easy to visually spot one cell reference that's wrong, because 20 cells connect to corresponding cells with parallel lines, then one isn't parallel. Ctrl+Tilda toggles show/hide formulas, which helps identify input cells when you inherit a messy spreadsheet.