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 sort with SORTBY function using a custom list. We use the custom list to specify a custom order.
In this video, we'll look more closely at calculated columns in Excel Tables, a feature to automatically enter and maintain formulas.
In this video, we look at how to make conditional formatting variable, so that you can change how formatting is applied without editing a rule. This elegant technique helps you build killer spreadsheets that are fun to use.
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 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.

Download 200+ Excel Shortcuts

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