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 use conditional formatting to highlight entire rows using multiple criteria.
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 an easy way to test a conditional formatting formula before you create the rule.
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.
Some Excel formulas are complex. But all complex formulas are built from simple steps. In this video, we built a more complex formula step by step.