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.
Intro to boolean logic
In this video, I'm going to show you the basics of boolean logic. Boolean logic is a great tool for simplifying formulas, especially those with many IF statements.
Boolean algebra in Excel
In this video, we’ll look how Boolean algebra is used for AND and OR logic in formulas. In Boolean algebra, there are only two possible results for a math operation: 1 or 0.
SORT and SORTBY with multiple columns
In this video, we’ll look at how to sort by multiple columns with the SORT and SORTBY functions.
Conditional formatting formula in a table
In this video we'll look at how to apply conditional formatting to a table with a formula.
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.