Exceljet

Quick, clean, and to the point

Enter and move down

Windows shortcut 
Enter
Mac shortcut 
Return

This isn't really a shortcut, but it's important to understand that pressing enter or return will complete a cell entry and move the cursor down by one cell. Using other keys (like the tab and arrow keys) you have the option to move the cursor in other directions after completing the entry in a cell.

222 Excel Shortcuts for Windows and Mac

Related videos

Tip: How to create a running total in a Table
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 plot survey data in a bar chart
How to plot survey data in a bar chart
In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for creating an "other" bucket.
Tip: How to use VLOOKUP with an Excel Table
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
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.