Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

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: https://www.excelcampus.com/tips/enter-key-behavior/

Additional Resources:
00:00 Introduction
00:11 How to Change the Behavior of the Enter Key in Excel
01:09 Altering Enter Key Behavior