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 chart generations with floating bars
In this video, we'll plot American generations in a chart with floating bars. This seems like a simple problem, but a solution takes a little creative thinking.
The SEQUENCE function
In this video, we'll introduce the SEQUENCE function. The SEQUENCE function lets you generate numeric sequences, which can be used for dates, times, and more.
XLOOKUP with boolean logic
In this video we'll look how to use the XLOOKUP function with Boolean logic to apply multiple criteria.
How to create a reference to another worksheet
In this video, we'll look at how to create formulas that reference cells on different worksheets, or even in different workbooks
Formulas to query a table
Because tables support structured references, you can learn a lot about a table with simple formulas. In this video, we'll look at some formulas you can use to query a table.