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
Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular Excel shortcuts you can use to save time every day in Excel. We built this list of shortcuts based on a survey of over 800 Excel users.
In this video, we introduce the concepts of boolean values and boolean logic. Boolean logic can be a great way to simplify and speed up complex formulas, since it requires no branching.
In this video, we'll look at how you can use the CHOOSE function for simple lookups. The CHOOSE function doesn't need an external table, and can sometimes replace more complicated formulas based on VLOOKUP, INDEX and MATCH, or nested IFs.
Download 200+ Excel Shortcuts
Your videos are the best one I have seen so far. I use excel in my advanced acc. techniques course and may be coming back to you for some tailored chosen set of videos. - Joanna
