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.
SEQUENCE of times
In this video, we'll look at how to generate a sequence of times with the SEQUENCE function.
Shortcuts to enter data
In this lesson, we cover shortcuts you can use to to enter data in one or more cells at a time. Knowing these tips can really speed up editing in Excel.
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.
Sort by custom list with SORTBY
In this video, we'll look at how to sort with SORTBY function using a custom list. We use the custom list to specify a custom order.

Download 200+ Excel Shortcuts

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