Change the Cursor Movement Direction in Excel

Open Microsoft Excel, type any text or number in any cell and press Enter on your Keyboard. You will see cursor moves top to down. 

Do you know why cursor moves top to down?

As it is a general practice and most of the data is entered into columns so Excel comes with the default option Top to Down.

Sometimes for data entry work, we need to put data in rows like left to right. In this case, either you can use Tab button to move left to right or can change cursor's movement direction.

Following 3-step process will show you how to change the cursor movement direction in Excel.

Step-1:

Open Microsoft Excel 2007, Click on the File tab of the ribbon to open the file menu and click on Excel Options as shown in following snapshot.

Change the Cursor Movement Direction in Excel

Step-2:

Select Advanced tab in the left pane of the Excel Options dialog box.

Select Down, Right, Left or Up direction under “After pressing Enter, move selection” in the right pane.

Change the Cursor Movement Direction in Excel

Once you have selected the desired option, the cursor will move in the selected direction.

Step-3:

Now you can test it yourself. Enter a value in any cell and press Enter to check whether it is working or not.

If you face any difficulty/issue, write to us in comment section.

Subscribe to get free tech advice, tips and in-depth articles.


Start Your Dream Website Today & Earn Money Online

To Start a dream website, choose a Domain Name & Reliable Hosting Provider, Self-hosted Blogging Platform, WordPress Theme, Email Marketing and SEO Tool for traffic.

SiteGround Hosting Discount - 60% OFF
ConvertKit The Best Email Marketing Software
Free SEMRush SEM and SEO Tool
Get Your Hosting Package with SiteGround, Increase new email subscribers with ConvertKit and Research Keywords with SEMRush to Boost Organic Traffic.





Leave a Reply

Your email address will not be published. Required fields are marked *