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

Related videos

The videos below demonstrate this shortcut.
When working with more advanced formulas, especially array formulas, you need to know how to convert TRUE and FALSE values in Excel to their numeric equivalents, 1 and 0. In this video, we'll look at some ways you can convert TRUE and FALSE values in Excel to 1s and 0s.
In this video, we'll look at how to create a scatter plot, sometimes called an XY scatter chart, in Excel.
This video provides a brief introduction to structured references. Structured references are an easy way to refer to tables in Excel formulas.
In this video, we look at how to create a basic column chart in Excel, and how to use custom number formats to show dates as month names, and currency in thousands.
In this video, we'll look at how to make a stacked area chart. Stacked area charts are useful to show changes in a part-to-whole relationship over time.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.