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 create a list of random dates with the RANDARRAY function.
Some Excel formulas are complex, but all complex formulas are built from simple steps. In this video we build a more complex formula step-by-step.
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.
In this video, we'll look at the options available for Excel Tables, including automatic range expansion and a setting to automatically fill formulas.
In this video, we'll use the FILTER function, with the LARGE and SMALL functions, to show the top or bottom results in a set of data.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.