Constants: This is the fastest way to audit a spreadsheet for errors. It finds every cell that contains a manually typed ...
The Alt+Enter shortcut isn't limited to new formulas you write—you can go back and clean up any messy formulas at any time.