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.
