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 create a Pareto chart. A Pareto chart plots the distribution of data in columns by frequency, sorted in descending order.
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.
Because tables support structured references, you can learn a lot about a table with simple formulas. In this video, we'll look at some formulas you can use to query a table.
In this video, we'll look at how to create formulas that reference cells on different worksheets, or even in different workbooks
In this video, we'll look at an easy way to test a conditional formatting formula before you create the rule.
