How to Enter within a Cell in Excel (5 Methods)

If you want to Enter within a Cell in Excel, this article is for you. Here, we describe 5 methods to enter within a cell in Excel.

Download Workbook


5 Methods to Enter within a Cell in Excel

The following Employee List table shows ID No, Name, and City columns. Using this table we will show you how to enter within the cell. Here, we used Excel 365. You can use any available Excel version.

How to Enter within a Cell in Excel


Method-1: Using Keyboard Shortcut to Enter within a Cell

Here, we will use a keyboard shortcut to enter within a cell.

In the following picture, we click on cell D4, and we want to enter the same cell.

How to Enter within a Cell in Excel

However, after we press ENTER, we automatically move to the down cell D5.

➤ To remain in the same cell D4, first of all, we have to type CTRL+ENTER.

➤ Now, if we press ENTER, we stay in the same cell D4.

Let’s create a line in the same cell.

➤ To do so, we will type ALT+ENTER in our cell D4.

We can see a new line is created in the same cell.

➤ Now, we can type anything in cell D4, and press ENTER.

Finally, we can see two lines of data in cell D4.

How to Enter within a Cell in Excel

Read More: How to Go to Next Line in Excel Cell (4 Simple Methods) 


Method-2: Stay in Same Cell after Pressing ENTER with Excel Options

In this method, we will use the Advanced Excel option to enter the same cell.

➤ First of all, we will go to the File tab in the ribbon.

How to Enter within a Cell in Excel

➤ After that, we will select Options.

An Excel Options window will appear.

➤ Now, we will select Advanced, we will unmark After pressing Enter move selection, and we will click OK.

➤ Finally, we can see that even if we press ENTER in cell D4, we stay in the same cell D4.

Read More: New Line in Cell Formula in Excel (4 Cases)


Similar Readings


Method-3: Using TEXTJOIN Function to Enter within a Cell

In this method, we will use the TEXTJOIN function to put together the values from multiple cells and enter within a cell. In Excel for Office 365, Excel 2019, and Excel 2019 for Mac, we can use the TEXTJOIN function

➤ To begin with, we will type the following function in cell F4.

=TEXTJOIN(CHAR(10),TRUE,B4:D4) 

Here,

  • CHAR(10) adds a carriage return between each combined text value.
  • TRUE → tells the formula to skip empty cells.
  • B4:D4 → are the cells to join.

➤ Now, press ENTER.

We can see the result in cell F4.

➤ Now, we will select cell F4, and click on Wrap Text.

Here, we can see 3 lines in one cell F4.

➤ We will drag down the formula with the Fill Handle tool.

How to Enter within a Cell in Excel

Finally, we can see that all the cells from F4 to F13 contain 3 lines of information in one cell.

Read More: How to Put Multiple Lines in Excel Cell (2 Easy Ways)


Method-4: Using CONCATENATE Function

If you do not have Excel for Office 365, Excel 2019, and Excel 2019 for Mac, you can use the CONCATENATE function to put together the values from multiple cells and enter within a cell.

➤ First of all, we have to type the following formula in cell F4.

=B4&CHAR(10)&C4&CHAR(10)&D4

Here, the CHAR function helps us to insert line breaks in between.

➤ Now, we will press ENTER.

We can see the result in cell F4.

➤ We will drag down the formula with the Fill Handle tool.

We can see that the information from multiple cells is now put together in a single cell.

➤ We need to wrap the text, and therefore, we will click on cell F4, and then click on Wrap Text.

How to Enter within a Cell in Excel

Finally, we can see the wrap text with 3 line breaks in cell F4.

How to Enter within a Cell in Excel

Read More: How to Add New Line with CONCATENATE Formula in Excel (5 Ways)


Method-5: Using Replace Option to Insert Line Break in a Cell

In this method, we want to remove commas from ID No, Name and City, and we want to insert line breaks instead. Here we will use the Replace option to do the task.

➤ First of all, we will select the entire dataset of the table.

➤ Then, we will go to the Home tab > Editing option > Find&Select option > Replace option.

A Find and Replace window will appear.

➤ We will type a comma ”,” in the Find what box.

➤ After that, in the Replace with box, we will press CTRL+J, and then we will select Replace All.

A Microsoft Excel window will appear.

➤ We will click OK.

Finally, we can see there is no comma in the Employee List table.

Now, to see line breaks in a cell between the ID No, Name, and City, we have to click on any of the cells.

➤ Here, we selected the merged cell B4:D4, and we click on Wrap Text.

How to Enter within a Cell in Excel

Finally, we can see 3 line breaks in the merged cell B4:D4.

How to Enter within a Cell in Excel

You can do the same for the others following the process.

Read More: How to Replace Line Break with Comma in Excel (3 ways) 


Conclusion

Here, we tried to show you some easy and effective methods that will help you to enter a cell in Excel. We hope you will find this article helpful. If you have any queries or suggestions, please feel free to know us in the comment section.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo