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 Calculated Columns
In this video, we'll look more closely at calculated columns in Excel Tables, a feature to automatically enter and maintain formulas.
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.
Conditional formatting formula in a table
In this video we'll look at how to apply conditional formatting to a table with a formula.
How to generate random text values
In this video, we'll look at how to create a list of random text with the RANDARRAY function and INDEX function.
How to use INDEX and MATCH with a table
In this video, we'll look at how to use INDEX and MATCH with an Excel Table. Using INDEX and MATCH with an Excel Table is wonderfully straightforward.