I recently saw a coworker type out a SUM formula in Excel to get a quick total, only to delete it a second later. When I showed him a pro shortcut hidden in plain sight, he realized he'd been wasting ...

If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled range. Simply reference the first cell of the spilled range with a # ...