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.
Related videos
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.
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.
Download 200+ Excel Shortcuts
Comments welcome! Read this before posting a question.