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:
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.
No comments:
Post a Comment