How to change Editing order in Excel From down to right Cell?
Posted: Mon May 16, 2016 3:39 pm
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
attachment 1.jpg