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.
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.
How to generate random times
In this video, we'll look at how to create a list of random times with the RANDARRAY function.
Two-way summary with dynamic arrays
In this video, we'll look at how to create a two-way summary with dynamic array formulas. The result is a summary table that's very similar to a pivot table.
List duplicate values with FILTER
In this video, we'll look at how to list duplicate values with the FILTER function. In other words, values that appear more than once in a set of data.
How to count unique values
In this video, we'll look at how to count the unique values returned by the UNIQUE function, together with other functions like FILTER and COUNTA.

Download 200+ Excel Shortcuts

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