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.
