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

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

9 Responses to Ctrl+Enter won’t let you down!

  1. Jim says:

    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)


  2. Pingback: Excel Roundup 20150223 « Contextures Blog

  3. XOR LX says:

    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:-)



  4. XOR LX says:

    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!



    • MF says:

      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 !?



    • Doug Glancy says:

      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.


Leave a Reply to XOR LX Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.