For example, if you want to add the values in cells A1, A2, and A3, type the below and hit Enter. =A1+A2+A3 Excel also lets you combine direct numbers and cell references in the same formula.

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 ...