enter multiple line in cell in Excel

Q51. In Excel, how can I enter multiple lines of data in a cell?

For example, I have a "Comments" column in my table where I provide detailed descriptive comments (see below). To make it easier to read, I would like to enter information in multiple lines.

Even if I wrap text, each of the comments do not appear in its own line.

excel enter multiple line in cell

excel excel enter multiple line in cell

To do it in Excel, here is the answer:

a) Position the cursor where a line break is required and then click on "Alt + Enter". In the screenshot below, the cursor is at end of comment 1 before start of comment 2.

Repeat the process as required.

excel excel excel enter multiple line in cell

b) Now each comment is in its own row within the same cell after line breaks are introduced using "At+Enter".

excel excel excel excel enter multiple line in cell

 

You can find similar Excel Questions and Answer hereunder

1) How can I avoid updates to cell values during macro execution?

2) Vlookup to return multiple values in same cell in Excel

3) How can I add and link a Chart Title to a cell value?

4) How can I get input from user through a prompt and assign user's input to a cell?

5) I want a formula to concatenate multiple cell values separated by a line break.

6) How can I sort data using multiple criteria?

7) How can I identify the cells that are dependent on a particular cell?

8) I want to add a trend indicator symbol next to my sales data - how can I do that?

9) How can I ensure that user enters only certain acceptable values in an input cell?

10) Line break in vba message box in Excel

11) Split one long column into multiple smaller columns in Excel

12) How can I find the last used cell in a Column in VBA?

13) Remove the apostrophe cell text values in Excel

14) Split string into multiple columns in Excel

15) How can I identify all cells with Data Validation in my WorkSheet?