Cancel selection
Windows shortcut
Esc
Mac shortcut
Esc
Pressing the escape key while editing a cell aborts the operation and leaves the cell in it's original state.
Related videos
Calculating a running total in an Excel table is a little tricky, because it's not obvious how to build the formula with structured references. You can easily get the current row with the @ notation, but what about the first row in a column? You might be surprised that you can use INDEX for this.
