Exceljet

Quick, clean, and to the point

Enter and move right

Windows shortcut 
Tab
Mac shortcut 
Tab

This shortcut is an alternative to pressing enter/return when entering data. It's useful when the next value you want to enter is to the right.

Related videos

Tip: How to create a running total in a Table
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.
Tip: How to use VLOOKUP with an Excel Table
This video shows how to setup VLOOKUP with a table, and how to use the MATCH function inside VLOOKUP to generate a dynamic column index. This makes it easy to refer to columns by name inside VLOOKUP, instead of hardcoding the column number. As a bonus, you can reorder the columns and the formula will keep working correctly.
Tip: Shortcuts to enter data in Excel
Did you know you can use shortcuts to control the direction Excel moves when you press Enter? In this video, learn a boatload of shortcuts for entering data in Excel.