Excel is well known ... select the cell containing the formula, and click the cell reference in the formula bar. Make sure you select a cell in the table before using this shortcut.

Every Excel expert knows how to navigate without a mouse and how to format data using keyboard shortcuts. But do you know how to insert a sum without typing the formula? Have you struggled to ...