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 a core concept in dynamic array behavior - spilling and the spill range.
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 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.
Setting up a running total in an Excel table is a bit tricky because it's not obvious how to use structured references. This video explores some options.
In this video, we'll plot American generations in a chart with floating bars. This seems like a simple problem, but a solution takes a little creative thinking.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
