# How to Create Rows within a Cell in Excel (3 Methods)

Get FREE Advanced Excel Exercises with Solutions!

In this instructive session, Iâ€™ll show you 3 handy methods on how to create rows within a cell in Excel.

Watch Video â€“ Create Rows within a Cell in Excel

## How to Create Rows within a Cell in Excel: 3 Methods

Letâ€™s introduce todayâ€™s dataset where the Name of some employees is provided along with their corresponding States and E-mail (these are located sequentially). Now, you need to create multiple rows to keep the given information within a cell.

Letâ€™s explore the methods.

### 1. Using Wrap Text Feature

In the beginning method, youâ€™ll see the application of the Wrap Text feature in Excel. Please do the following steps.

Step 01: Apply the Wrap Text Feature

âžœ First, select the entire dataset (e.g. B5:B9 cells)

âžœ Later, choose the Wrap Text feature from the Alignment ribbon (in the Home tab).

Step 02: Turn on AutoFit Row Height

In this step, you need to turn on the AutoFit Row Height option.

âžœ Just click on the drop-down list of the Format feature and choose the AutoFit Row Height option while selecting the cells.

Eventually, youâ€™ll get the following output where the Name, State, and E-mail address are located separately (multiple lines) within the single B5 cell.

Read More: How to Resize All Rows in Excel

### 2. Inserting Line Break

Another way to create multiple lines within a cell is to insert a line break after each piece of information.

âžœ So, go to after the Name (e.g. James Smith) in the B5 cell and press ALT + ENTER to add a line break in the cell.

âžœ Then, repeat the process in the rest cells after each information except the last information. You donâ€™t need to have a line break after the E-mail.

After using the AutoFitRow Height option, youâ€™ll get the following output.

### 3. Merging Rows to Create Multiple Rows within a Cell

Most likely, this method is the desired one that youâ€™re looking for! Certainly, you can create rows to keep information within a cell using this simple but effective method. For example, you can store the information available in the B5 cell in Row 5-7.

âžœ To do this, you need to select the B5:B7 cells and pick the Merge & Center option from the Home tab.

âžœ Subsequently, type or copy-paste (CTRL + C to copy and CTRL + V to paste) Name and then press ALT + ENTER to insert a line break.

âžœ Later, type another information (e.g. States) in the newly created line.

After adding an E-mail, youâ€™ll get the following output.

## Conclusion

Thatâ€™s the end of todayâ€™s session. I strongly believe from now you can easily create rows within a cell in Excel. Anyway, if you have any queries or recommendations, please share them in the comments section.

## Related Articles

<< Go Back to Rows in Excel | 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.