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.
Structured reference syntax examples
Structured references are used to refer to Excel tables in formulas. In this video, we get into the nitty gritty with many examples.
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.
How to test a conditional formatting formula
In this video, we'll look at an easy way to test a conditional formatting formula before you create the rule.
How to use the CHOOSE function
In this video, we'll look at how you can use the CHOOSE function. We also compare a formula based on CHOOSE vs. a formula based on VLOOKUP.
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.