Afia Kona
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.
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.
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.
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.
➤ 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
- How to Replace a Character with a Line Break in Excel (3 Easy Methods)
- How to Add a Line in Excel Cell (5 Easy Methods)
- Find and Replace Line Breaks in Excel (6 Examples)
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.
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)&D4Here, 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.
Finally, we can see the wrap text with 3 line breaks in cell F4.
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.
Finally, we can see 3 line breaks in the merged cell B4:D4.
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.
