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.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.
How to build a column chart
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.
XLOOKUP with boolean logic
In this video we'll look how to use the XLOOKUP function with Boolean logic to apply multiple criteria.
Basic SORTBY function example
In this video, we’ll look at a basic example of sorting with the SORTBY function. With the SORTBY function, you supply sort order in pairs of inputs. Each pair has an argument for range, and an argument for sort order.
FILTER function with two criteria
In this video, we’ll set up the FILTER function with two criteria.
How to use SUMIFS with an Excel Table
In this video, we'll look at how to use the SUMIFS function with an Excel table, with a side-by-side comparison without a table.

Download 200+ Excel Shortcuts

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