Setting to automatically moving the cell pointer in Microsoft Excel 2013

This blog post will explain how to change the settings to automatically move the cell pointer after entering data in Microsoft Excel 2013 .

Setting to automatically moving the cell pointer in Microsoft Excel 2013

Microsoft Excel by default moves the cell pointer to the next cell below (next row) whenever you press an enter key. You can modify this behaviour via the Excel Options Dialog .

Follow the below steps to change the settings of automatically moving the cell pointer in Microsoft Excel 2013.

1. Navigate to File -> Options and select the Advanced Tab in the Excel Options Dialog.

image
2. Check the option “After pressing Enter move selection” and select the direction to other option apart from Down.

image

3. Click Ok .

4. Now , enter the data in a call and press the enter key . You will notice the difference in how the cell pointer navigates as soon as you presses the enter key.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to insert bullets in to cells in Microsoft Excel ?
Do you want to insert bullets in cells of Microsoft Excel?. Here's how you can do it. How to insert ...
How to resize print area and fit to Single page in Excel 2016 ?
When you try to print a worksheet in Microsoft Excel 2016 , you may notice that the content might ov...
How to find the Created and Last Modified time in Microsoft Excel ?
You can easily find out the exact date and time when the excel workbook was created and modified usi...