How Write a Sentence in a Cell in Excel Then Continue Into Another Cell

In most applications, you can easily go to the next line by just pressing Enter. But in Excel, this process is a little different. You can use the keyboard shortcut, find and replace option, or some formulas to go to the next line in an excel cell. In this article, we will demonstrate 4 simple methods to go to the next line in an Excel cell. So, without further ado, let's start the discussion.


Download Practice Book

Download the practice book here.


4 Methods to Go to Next Line in Excel Cell

To explain the methods, we will use a dataset that contains information about the Sales Amount. We will try to go to the next line while writing comments on the dataset.


1. Use Keyboard Shortcut to Go to Next Line in Excel Cell

In Excel, you can use a keyboard shortcut to go to the next line in a cell very easily. This is the easiest method of all. We use different shortcuts for Windows and Mac. Follow the steps below to learn the method.

STEPS:

  • First of all, type a word in Cell D5. We have written Performance in Cell D5.
  • Now, to go to the next line, press Alt + Enter if you are a windows user. For mac, press Control + Option + Return.

Use Keyboard Shortcut to Go to Next Line in Excel Cell

  • After pressing Alt + Enter, you will see results like the picture below.

Use Keyboard Shortcut to Go to Next Line in Excel Cell

  • You can use the shortcut after each word to go to the next line in the same cell. Or, you can use it after the words you want.

Use Keyboard Shortcut to Go to Next Line in Excel Cell

  • After typing the full sentence or formula, you need to hit Enter to get out of editing mode.
  • Next, you need to adjust the height of the row. To do so, put the cursor on the division line between two rows and double-clickit.

Use Keyboard Shortcut to Go to Next Line in Excel Cell

  • Finally, you will see results like the picture below.

Use Keyboard Shortcut to Go to Next Line in Excel Cell

  • Alternatively, you can also use the shortcut after completing the full sentence. Just put the cursor before the word from where you need to go to the next line.

Use Keyboard Shortcut to Go to Next Line in Excel Cell

  • After placing the cursor before the desired word, press Alt + Enter. Mac users need to press Control + Option + Return.

Use Keyboard Shortcut to Go to Next Line in Excel Cell

  • Do the same for the rest of the cells to get results like the image below.

Use Keyboard Shortcut to Go to Next Line in Excel Cell

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


2. Go to Next Line inside a Cell Using Wrap Text in Excel

In this method, we will use the Wrap Text option to go to the next line in an excel cell. If you need to maintain a constant cell width, then, you must follow this method. To explain the steps, we will use a dataset that contains the comments. In this case, you can not autofit the column width.

Go to Next Line inside a Cell Using Wrap Text in Excel

Let's pay attention to the steps below to know more.

STEPS:

  • In the beginning, select the cells. Here, we have selected Cell D5 to D8.

Go to Next Line inside a Cell Using Wrap Text in Excel

  • Secondly, go to the Home tab and select Wrap Text.

Go to Next Line inside a Cell Using Wrap Text in Excel

  • After that, you will see results like the screenshot below. You just need to adjust the row height now.
  • To adjust the row height, put the cursor on the division line between two rows and double-clickit.

Go to Next Line inside a Cell Using Wrap Text in Excel

  • Finally, you will see results like the picture below.

Go to Next Line inside a Cell Using Wrap Text in Excel

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


Similar Readings

  • How to Add a Line in Excel Cell (5 Easy Methods)
  • How to Put Multiple Lines in Excel Cell (2 Easy Ways)
  • How to Replace a Character with a Line Break in Excel (3 Easy Methods)

3. Apply Formula in an Excel Cell to Create Next Line

In Excel, you can use some formulas to go to the next line inside a cell. We can build these formulas using the Ampersand (&) sign, the CONCATENATE function, or the TEXTJOIN function. To explain this method, we will bring the values of Cell B5, C5 & D5 to Cell E5.

3.1 Use Ampersand (&) Sign

We can use the Ampersand (&) sign to create a simple formula. Follow the steps below to learn the formula.

STEPS:

  • Firstly, select Cell E5 and type the formula:

=B5&CHAR(10)&C5&CHAR(10)&D5

  • In the second place, hit Enter to see the result.

Apply Formula in an Excel Cell to Create Next Line

In this case, we have the CHAR(10) function to introduce line breaks.

  • Now, use the Fill Handle down to see results in the rest of the cells.

Apply Formula in an Excel Cell to Create Next Line

  • After that, select the cells and then, go to the Home tab and select Wrap Text.

Apply Formula in an Excel Cell to Create Next Line

  • You will see results like below after selecting Wrap Text.

Apply Formula in an Excel Cell to Create Next Line

  • Next, adjust the row height by placing the cursor on the division line between two rows and double-clickit.

Apply Formula in an Excel Cell to Create Next Line

  • Finally, the cells will look like this.

Apply Formula in an Excel Cell to Create Next Line


3.2 Apply CONCATENATE Function

We can use the CONCATENATE function for the same purpose. Let's observe the steps below for this sub-method.

STEPS:

  • To begin with, select Cell E5 and type the formula:

=CONCATENATE(B5,CHAR(10),C5,CHAR(10),D5)

  • Then, hit Enter.

Apply Formula in an Excel Cell to Create Next Line

Here, to introduce line breaks, we have used the CHAR(10) function after every cell inside the formula.

  • After that, drag down the Fill Handle and select the desired cells.

Apply Formula in an Excel Cell to Create Next Line

  • Next, select Wrap Text from the Home tab in the ribbon.

Apply Formula in an Excel Cell to Create Next Line

  • Finally, adjust the row height to observe the below result.

Apply Formula in an Excel Cell to Create Next Line


3.3 Insert TEXTJOIN Function

Like the previous two methods, we can also use the TEXTJOIN function to build a formula to go to the next line in an excel cell. But the TEXTJOIN function is available in Excel 365 and Excel 2019 only. Follow the steps below for the procedure.

STEPS:

  • Select Cell E5 first and type the formula:

=TEXTJOIN(CHAR(10),TRUE,B5:D5)

  • After that, press Enter to see the result.

Here, the CHAR(10) function is used for line breaks. The second argument ignores the empty cells and the third argument contains the cells that need to be joined.

  • Next, autofill the formula in the below cells and select them.

  • Now, go to the Home tab and select Wrap Text.

  • In the end, adjust the row height to see results like below.

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


4. Insert Line Break with 'Find and Replace' Feature to Go to Next Line in Cell

Excel provides another option to introduce line breaks. Using the line breaks you can go to the next line easily. And that is to use the 'Find and Replace' option. Here, the dataset will contain the comments. Follow the steps below to learn this method.

STEPS:

  • First of all, select the cells where you want to introduce the line breaks.

  • In the second place, press Ctrl + H to open the Find and Replacewindow.
  • In the Find and Replace window, press the space key one time in the 'Find what'field.
  • Then, press Ctrl + J in the 'Replace with' field. You will not do anything on the field but it will add some special characters.

  • After that, press Replace All to see results like the picture below.

  • Finally, adjust the row height to see the below results.

Read More: Find and Replace Line Breaks in Excel (6 Examples)


Things to Remember

You could extra space while going to the next line inside an excel cell. This can create problems later. So, be extra careful about that.


Conclusion

In this discussion, we have demonstrated 4 easy methods to Go to the Next Line in an Excel Cell. Method-1 is the easiest of all. I hope these methods will help you to perform your tasks easily. Furthermore, we have also added the practice book at the beginning of the article. You can download it to learn more. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below.


Related Articles

  • How to Remove Line Breaks in Excel (5 Ways)
  • Excel VBA: Create New Line in MsgBox (6 Examples)
  • How to Replace Line Break with Comma in Excel (3 ways)
  • [Fixed!] Line Break in Cell Not Working in Excel
  • VBA to Generate Multiple Lines in Email Body in Excel (2 Methods)

moserpogmeher1984.blogspot.com

Source: https://www.exceldemy.com/go-to-next-line-in-excel-cell/

0 Response to "How Write a Sentence in a Cell in Excel Then Continue Into Another Cell"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel