Ctrl+Enter won’t let you down! - KING OF EXCEL

Monday, December 16, 2019

Ctrl+Enter won’t let you down!

Ctrl+Enter won’t let you down!

As you may be aware of, Ctrl+Enter enables you to input the same thing (be it text, value or formula) in multiple cells simultaneously.  See screenshot below for example:
Excel Tips - Ctrl Enter 1
It is quite handy and I use this trick a lot in daily work.
Nevertheless did you know that you may apply the same trick to stay on the active cell after you input a value?  
By default, pressing Enter takes you to the next cell downward.  However in many cases, you would like to stay in the active cell.  To do so, simply press Ctrl+Enter, not just Enter.
Excel Tips - Ctrl Enter 2
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

Popular Posts