When you are entering data in set of cells and press Enter key, by default it will move to the cell below in the column. But if you want to enter data across rows then, in Excel 2007 onward, click on Office button. Select Excel option and select Advanced button. In this tick the box marked "after pressing enter move selection" change the direction in drop-down list.
attachment 1.jpg
How to change Editing order in Excel From down to right Cell?
-
- Posts: 339
- Joined: Wed Mar 16, 2016 12:44 pm
How to change Editing order in Excel From down to right Cell?
You do not have the required permissions to view the files attached to this post.
Who is online
Users browsing this forum: No registered users and 1 guest