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

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Enter within a Cell in Excel: 5 Methods

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 Add New Line with CONCATENATE Formula in Excel 


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: Excel: Inserts New Line in Cell Formula 


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 


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


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.


Download Workbook


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


<< Go Back to New Line | Text Formatting | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo