Exceljet

Quick, clean, and to the point

Complete entry and stay in same cell

Windows shortcut 
CtrlEnter
Mac shortcut 
⌃Return

With a single cell selected, this shortcut will enter a value and leave the same cell selected.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.
How to count unique values
In this video, we'll look at how to count the unique values returned by the UNIQUE function, together with other functions like FILTER and COUNTA.
Sort by custom list with SORTBY
In this video, we'll look at how to sort with SORTBY function using a custom list. We use the custom list to specify a custom order.
Shortcuts to enter data
In this lesson, we cover shortcuts you can use to to enter data in one or more cells at a time. Knowing these tips can really speed up editing in Excel.
How to use INDEX and MATCH with a table
In this video, we'll look at how to use INDEX and MATCH with an Excel Table. Using INDEX and MATCH with an Excel Table is wonderfully straightforward.
3 basic array formulas
Why use array formulas? In this video we'll look at three basic array formula examples. Traditional array formulas can solve tricky problems, and building array formulas in the dynamic array version of Excel is easier than ever.

Download 200+ Excel Shortcuts

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