If you want to change the behavior of your Enter key for the long term, DRSteele's recommendation to change the setting in Excel Options is great. That's a really good tip for individual instances, and one I use often. If you don't want your selected cell to move down, you can press Ctrl + Enter instead of just Enter. This is the default behavior in Excel, but there are a few ways to change this.Ībout a month ago, we received a comment on one of our YouTube tutorials from a viewer called DRSteele, who indcated that their preference for the Enter key is that it doesn't make the active cell move at all.įellow commenter Joe M suggested a great one-at-a-time solution. Typically when you are editing a cell and press the Enter key, the cell below is selected. Preventing the Enter Key from Moving Down
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |