Wasim Akram
When working with Microsoft Excel, you may find problems with data or text not fitting properly in a cell. In that scenario, you need to wrap text or add a line break in the cell. In this article, I am going to show you how to add a line in an excel cell. Check this link for more information.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
5 Suitable Methods to Add a Line in Excel Cell
In the following, I have described 5 methods to add a line in the excel cell. Suppose we have a dataset containing some book names.
1. Use Keyboard Shortcut to Add a Line in Excel Cell
Using a keyboard shortcut is the most frequently used method to add a line in an excel cell.
Steps:
- Select the cell to add a line.
- Put the cursor in the cell where you want to add a line.
- Now press ALT+Enter.
- Thus you can add a line.
- In the following, we have added a line in each cell.
Read More: New Line in Cell Formula in Excel (4 Cases)
2. Apply Wrap Text Feature to Add a Line in Excel
Excel has some built-in features to add a line in an Excel cell.
By enabling the wrap text feature you can automatically add a line adjusting the cell.
Steps:
- Select cells to add a line. Here I have selected cell (B5) to cell (B9).
- Click the right button of the mouse to enable options.
- From the options choose “Format Cells”.
- A new window “Format Cells” will appear.
- From the “Alignment” section choose “Wrap Text”.
- Press OK.
- Here we have our text wrapped in all the selected cells.
To work quickly you can select wrap text from the Home ribbon.
- Select cells and apply “Wrap text” from the Home ribbon.
- Here we got all our text wrapped by using a single click.
Read More: How to Go to Next Line in Excel Cell (4 Simple Methods)
Similar Readings
- How to Replace Line Break with Comma in Excel (3 ways)
- Enter within a Cell in Excel (5 Methods)
- How to Remove Line Breaks in Excel (5 Ways)
3. Add a Line Break After a Specific Character in Excel Cell
Sometimes we may need to add a line break after a specific character. In this method, I am describing the method to do so.
Steps:
- Choose cells.
- Press: Ctrl+H.
- A new window “Find and Replace” will appear.
- In the “find what” section write “, “.
- Select the “Replace with” section and press Ctrl+J to insert the line feed.
- Click “Replace All”.
- A new window will appear confirming the replacement.
- Click OK.
- This way you can add a line in the excel cell after a specific character.
Read More: How to Replace a Character with a Line Break in Excel (3 Easy Methods)
4. Apply TEXTJOIN Function to Add a Line in Excel
With the use of different types of functions, you can add a line in excel. In this method, I am going to apply the TEXTJOIN function to add a line in the excel cell. Suppose we have a dataset containing some book’s names, their writer names, and published years.
Steps:
- Choose cell (E5).
- Apply the formula-
=TEXTJOIN(CHAR(10), TRUE, B5:D5)Where,
- The TEXTJOIN function combines text from multiple ranges or strings.
- The CHAR function returns a character when given a valid character code.
- B5:D5= It is the cell range.
- Press Enter.
- You will see all the characters in the cell range are added to the selected cell with a line break.
- Drag down the “Fill handle”.
- Thus we got all our cells with line breaks in a single cell.
Read More: How to Do a Line Break in Excel (4 Ways)
5. Use CONCATENATE Function to Add a Line in Excel Cell
Applying the CONCATENATE function you can also add a line in the excel cell.
Steps:
- Select a cell. Here I have chosen cell (E5) to add a line.
- Apply the formula-
=CONCATENATE(B5, CHAR(10), C5, CHAR(10), D5)Where,
- The CONCATENATE function joins two or more texts into one single text.
- The CHAR function returns a character when given a valid character code.
- Click Enter.
- Drag down the “Fill handle” to get results in every cell.
- Well, this is the simplest way to add a line in excel.
Read More: How to Add New Line with CONCATENATE Formula in Excel (5 Ways)
Things to Remember
- When using Mac instead of a PC use Char(13) and replace Char(10).
- Before applying the formula in the cell make sure to enable “Wrap Text”. Otherwise adding Char(10) would make no changes to the result.
Conclusion
In this article, I have tried to cover all the methods to add a line in excel. Hope you find it useful. If you have any queries regarding this article don’t forget to inform us in the comment section below. Thanks!
