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.

Dataset

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).

Using Wrap Text Feature

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.

Using Wrap Text Feature

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.

How to Create Rows within a Cell in Excel Using Wrap Text Feature

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.

Inserting Line Break

After using the AutoFitRow Height option, you’ll get the following output.

How to Create Rows within a Cell in Excel Inserting Line Break


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.

How to Create Rows within a Cell in Excel Merging Rows

➜ 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.

How to Create Rows within a Cell in Excel Merging Rows

After adding an E-mail, you’ll get the following output.

How to Create Rows within a Cell in Excel Merging Rows


Download Practice Workbook


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.
Md. Abdul Kader
Md. Abdul Kader

MD. ABDUL KADER is an engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SWM, GIS, RS, and SPSS. He holds a B.Sc in Urban & Regional Planning from Chittagong University of Engineering and Technology and has shifted to become a content developer. In this role, he crafts technical content centred around... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo