How to change Editing order in Excel From down to right Cell?

Tips and Tricks related to MS office application
ModeratorNA
Posts: 339
Joined: Wed Mar 16, 2016 12:44 pm

How to change Editing order in Excel From down to right Cell?

Postby ModeratorNA » 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
You do not have the required permissions to view the files attached to this post.

Return to “MS-Office”

Who is online

Users browsing this forum: No registered users and 1 guest