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.

Related videos

The videos below demonstrate this shortcut.
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.
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.
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.
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.
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.