Preventing Moving to the Next Cell after Typing in Microsoft Excel 2010

In this article, we will learn how we can prevent moving to the next cell after typing in Microsoft Excel 2010.

Let’s take an example to understand how we can prevent moving to the next cell after typing.

Open Excel file. Now, in cell A1, type any word which you want to prevent moving to the next cell after typing in Microsoft Excel.

Prevent moving to the Column, follow below given steps:-

  • Select the cell A1 and type Excel tip.

 
img1
 

  • Select the cell A1, then select the range A1:A10 by pressing the key Ctrl+down arrow key on your keyboard.
  • Press the key F2 on your keyboard.

 
img2
 

  • Press the key Ctrl+Enter on the keyboard.
  • Same text will get copied in the selected range.

 
img3
 
To prevent moving to the Row, follow below given steps:-

  • Select the cell A1 and type Excel tip.
  • Select the cell A1, then select the range A1:E1 by pressing the key Ctrl+right arrow key on your keyboard.
  • Press the key F2 on your keyboard.

 
img4
 

  • Press the key Ctrl+Enter on the keyboard.
  • Same text will get copied in the selected range.

 
img5
 
This is all about how we can prevent moving to next cell after typing in Microsoft Excel.
 
 

Comments

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.