Ask Sawal

Discussion Forum
Notification Icon1
Write Answer Icon
Add Question Icon

How to go down in same cell in excel?

3 Answer(s) Available
Answer # 1 #
  • Double-click the cell in which you want to insert a line break.
  • Click the location inside the selected cell where you want to break the line.
  • Press Alt+Enter to insert the line break.
Roopa Anchal
Power Plant Operators
Answer # 2 #

When using Excel for storing and manipulating text entries, you may sometimes want a certain part of a text string to start in a new line. A good example of multi-line text could be mailing labels or some personal details entered in one cell.

In most Office applications, starting a new paragraph is not a problem - you simply press Enter on your keyboard. In Microsoft Excel, however, this work differently - pressing the Enter key completes the entry and moves the cursor to the next cell. So, how do you create a new line in Excel? There are three swift ways to do this.

That's how to add a carriage return in Excel. I thank you for reading and hope to see you on our blog next week!

Dirk Ontiveros
Chief Design Officer
Answer # 3 #

Normally, when you finish the content in a cell and press Enter key, the cursor will be moved to the next cell by default. But, sometimes, you just need stay in the same cell after pressing the Enter key. This article, I will introduce you some quick tricks to solve this job in Excel.

Stay in the same cell after pressing the Enter key with Excel Options

Stay in the same cell after pressing the Enter key with Shortcut Keys

In Excel, you can go to the Excel Options to set the option for changing the direction of the cursor after pressing the Enter key, please do as follows:

1. Click File > Options to go the Excel Options dialog.

2. In the Excel Options dialog box, click Advanced from the left pane, and in the right list box, under the Editing options section, uncheck After pressing Enter, move selection, see screenshot:

3. And then click OK button, from now on, when you enter the content into a cell and press Enter key, the input cell is still selected but not move.

CCH Walser
Technical Director