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.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.
How to use the CHOOSE function
In this video, we'll look at how you can use the CHOOSE function. We also compare a formula based on CHOOSE vs. a formula based on VLOOKUP.
FILTER data between two dates
In this video, we’ll look at a couple ways to use the FILTER function to extract data between dates.
How to use Calculated Columns
In this video, we'll look more closely at calculated columns in Excel Tables, a feature to automatically enter and maintain formulas.
XLOOKUP with boolean logic
In this video we'll look how to use the XLOOKUP function with Boolean logic to apply multiple criteria.
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.

Download 200+ Excel Shortcuts

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