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.
Like Doug, I’ve always set Excel to stay in the same cell after Enter (so I can still see a formula I’ve just entered – it now confuses me when I use another’s machine)
If I WANT to move after enter, I select the range first, then Enter will progress through the selection (down then across; Tab for across then down)
In case you want to navigate in a “Z” direction, you don’t have to select the range first.
Tab Tab Tab Enter would do:
Pingback: Excel Roundup 20150223 « Contextures Blog
Ah, yes. I suppose that use re entering formulas is quite handy. Thanks!
Still – we’re only talking about saving one simple press of the up arrow afterwards, aren’t we? Now that is what I call efficiency:-)
=Aggregate(1 simple press or click, various situation) returns Efficiency! 🙂
Nice! Never new that one!
Scratching my head a bit for a practical reason why you might particularly want to stay in the same cell after entering, though?
Another good practical tip. Keep them coming!
I did had a practical usage in the past. That was a simple spreadsheet to lookup product information by inputting product code. The thing is the spreadsheet was designed for enquiry one by one… every time a UPC was input, I had to move up again for the next input… Imagine how cumbersome it was.
With Ctrl Enter, I skipped the repetitive action of moving cell up. haha 🙂
On the other hand, I use this trick when testing a formula. For many times, I input various contents into a cell to test my formula works for different input. I guess many people do that too !?
I always set Excel to stay in the same cell after hitting Enter. I can’t even tell you exactly why any more, but it’s way more efficient for me.
Thanks for your comments. I can imagine how this little trick could help. Glad that you like it! 🙂