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 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 plot American generations in a chart with floating bars. This seems like a simple problem, but a solution takes a little creative thinking.
In this video, we'll look at how to dynamically highlight high and low values in an Excel chart using data labels.
This video provides a brief introduction to structured references. Structured references are an easy way to refer to tables in Excel formulas.
In this video, we'll look at how to use conditional formatting to highlight entire rows using multiple criteria.
