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 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.
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.
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
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.
Get The recent News
Follow united state on social media to continue to be up to day with the recent tips in Excel!