How to Change the Behavior of the Enter Key in Excel

About this tutorial:

Video duration: 00:03:38
In this video I explain how to change what happens when you press the Enter key in Excel. Typically, pressing the Enter key will select the cell below the active cell when editing a cell/formula.

However, there are ways to prevent the selection from moving when hitting the Enter key. We can even change the behavior in the settings within Excel Options.

I also explain a quick tip for using the Tab key when doing data entry on Excel Tables.

Read the full blog post:

Additional Resources:

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

14 thoughts on “How to Change the Behavior of the Enter Key in Excel

    Lucy Lei

    (May 30, 2020 - 8:28 pm)

    Hi, just found your videos since I'm a beginner at excel and my enter key isn't working on the spreadsheet. I've tried control, the alt option and the return/enter key with different combinations using all and of these separate keys but nothing seems to be able to get the SUM. I'm on a mac and can't seem to find videos relating to this situation, only found videos regarding starting a new line which isn't what I'm looking for.

    Esther Victor

    (May 30, 2020 - 8:28 pm)


    John Adair

    (May 30, 2020 - 8:28 pm)

    Great video. I love the Ctrl+Enter combo. I use it a lot! I love the Shift+Tab combo to move backwards from field to field in other software programs, too. You can use the Tab to move forward & Shift+Tab to move back on most any web page when filling out an application. That greatly saves you from having to use the mouse so much.


    (May 30, 2020 - 8:28 pm)

    Doctor!? Thanks for the grand promotion, Jon – that's sure to impress the ladies. Actually D and R are just my initials…but thanks tons for the recognition. Super video, thorough treatment. Well done.

    Ameer Mohammad

    (May 30, 2020 - 8:28 pm)

    Hii john can you direct me to any videos how to insert a copied cell without using a mouse. Thanx

    Kuan Tam

    (May 30, 2020 - 8:28 pm)

    How u doing sir . Do u have risk reward Ratio Formula for trading ? Thx

    Kunchok Tharlam

    (May 30, 2020 - 8:28 pm)

    Hi Jon,
    It was good to know those basic. Thanks for uploading this video. I have a question about copying value from one sheet and pasting it in a filter sheet without skipping the value. I tried in three different formats. Firstly: normal copy and paste
    Secondly: copy and special pasting
    Lastly: (with formula) above cell +1
    Do you have another way to do it? Please let me know. 🙂

    Wayne Edmondson

    (May 30, 2020 - 8:28 pm)

    Thanks for this review Jon. Nice to have personal preference, although I keep mine at default down because that matches the behavior of most colleagues.. so.. keeps me compatible with what the people around me are doing.. for what it's worth. Thumbs up!


    (May 30, 2020 - 8:28 pm)

    Thank you John, very useful

    J J

    (May 30, 2020 - 8:28 pm)

    Nice video

    naif Al-Amodi

    (May 30, 2020 - 8:28 pm)

    Thank you Jon
    I have a question regarding pivot tables
    Can I build one from different ranges sheets?

    imran ali

    (May 30, 2020 - 8:28 pm)

    Basic video but nyc

    Tamu Schwoeffermann

    (May 30, 2020 - 8:28 pm)

    Don't forget Shift + Enter, Alt + Enter, and Ctrl + Shift + Enter

    Kathy Rusinski

    (May 30, 2020 - 8:28 pm)

    Very useful!  Thank you

Leave a Reply

Your email address will not be published. Required fields are marked *