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.
In this video, we'll look at how to resize and copy charts, including a way to snap the chart to cells.
In this video, we’ll look at a core concept in dynamic array behavior - spilling and the spill range.
Dynamic Arrays are the biggest change to the Excel formula engine in years. In this video, I'll explain the basic idea of dynamic array formulas.
In this video we'll look at how dynamic array behavior is native and deeply integrated in Excel. Even older functions can use this new feature.
In this video, we'll look at how boolean operations are used in array formulas. This is a key concept in developing more advanced dynamic array formulas.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
