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.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.
How to generate random dates
In this video, we'll look at how to create a list of random dates with the RANDARRAY function.
How to create a complex formula step by step
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.
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.
Excel Table Options
In this video, we'll look at the options available for Excel Tables, including automatic range expansion and a setting to automatically fill formulas.
How to show top or bottom n results
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.