By default as soon as typing data or a formula right into a cell and also pressing enter, the active cell cursor will relocate down one cell. You don’t need to be stuck to this if girlfriend don’t desire it though. Girlfriend can also have it walk up, left, right or not move at every if friend want. I personally prefer the energetic cell cursor to stay on the cell I simply finished typing in as this renders it easier to copy and paste what you simply finished entering.

You are watching: What does pressing the enter key while in a cell, do?


Change the default setting.

Go to the File tab.Select Options from the menu.In the Options window choose Advanced.Under the the Editing options uncheck the After pressing Enter, relocate selection box if you desire the energetic cell cursor no to relocate after pressing enter.Select a direction if you desire the energetic cell cursor to move a direction other than under after pressing enter.Press the OK button.

About the Author


John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, strength BI, strength Automate, strength Apps and SharePoint. You can uncover other interesting articles from man on his blog or YouTube channel.

Related Articles

Browse all Posts

37 awesome Excel mouse Tips & tip You have to Know

Apr 15, 2019

While the keyboard is usually quicker, you shouldn’t totally ignore the mouse. Over there are additionally some an excellent time saving mouse shortcuts as well. In this article we’ll take it a watch at few of the ideal Excel computer mouse time saving tips and tricks.

read more

25 amazing Power ask Tips and Tricks

Jun 11, 2018

Power questions is amazing tool that allows you to import and transform data v ease and also helps to develop repeatable and also robust measures with your data. Here are part tips and also tricks to help you obtain the many out strength Query.

See more: If Two Lines Are Perpendicular, Then They Form ? Properties Of Perpendicular Lines

read more

Amazing Excel Tips and Tricks

May 12, 2018

A compilation of the ideal Excel tips and also tricks varying from beginner to agree that will conserve you time and also make you an ext productive.

read more



Get The recent News

Follow Us

Follow united state on social media to continue to be up to day with the recent tips in Excel!