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 just transition into a role related to data analytics at current company......😊 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.


Comments, suggestions, corrections are welcome.

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 )

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.