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.

If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled ...

Sean Ross is a strategic adviser at 1031x.com, Investopedia contributor, and the founder and manager of Free Lances Ltd. Gordon Scott has been an active investor and technical analyst or 20+ years. He ...