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 generate a sequence of dates with the SEQUENCE function.
In this video, we'll look at how to create a list of random times with the RANDARRAY function.
In this video we'll look how to use the XLOOKUP function with Boolean logic to apply multiple criteria.
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.
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.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
