# How to Insert a Row Within a Cell in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

When we work with Excel sometimes, we need to insert extra rows. Adding new rows can be done via the ribbon, keyboard, and mouse. Here we are going to provide some ways to insert a row within a cell in Excel. We always try to introduce the easiest and maximum possible ways, so that everyone gets their desired result. We are going to provide instructions on how to insert a row or more rows within a cell in Excel.

## How to Insert a Row Within a Cell in Excel: 3 Easy Ways

Here we will use a sample dataset, which indicates Student names and their marks in different subjects.

### 1. Use Ribbon to Insert a Row in Excel

You can insert single or multiple rows using Ribbon in Excel by going through some simple steps.

#### 1.1 Use Cell to Insert a Row

Here we will describe how to insert a single row by selecting a Cell.

Steps:

• Firstly, select one cell within the sheet.
• Then, go to the Home tab >> click on Cells >> click on Insert >> select Insert Sheet Rows from the drop-down.

• Thus, you will get a new row.

#### 1.2 Utilize Row to Insert a Row

You can do this by selecting a Row also.

Steps:

• In the beginning, select one row within the sheet.
• After that, go to the Home tab >> click on Cells >> click on Insert >> select Insert Sheet Rows from the drop-down.

• Finally, you will get a new row.

Note:Â The Insert Options button will appear next to the added cells when you add new rows. The format of these cells in Excel can be selected with this button. Formats of the added rows are by default in a similar way to the cells in the row above. Click the drop-down arrow after placing the mouse over the Insert Options button to see more options.

#### 1.3 Insert Multiple Rows Within a Cell

We can also insert multiple rows using the above-mentioned methods.

To insert multiple rows by using multiple cells, go through the steps given below.

Steps:

• Firstly, select the required number of cells within the sheet.
• Then, go to the Home tab >> click on Cells >> click on Insert >> select Insert Sheet Rows from the drop-down.

• Now, we will see that three rows are inserted here, as we selected three cells.
• However, you can select as many cells and increase rows as well.

#### 1.4 Add Multiple Rows Using Row

You can also insert multiple rows by selecting rows.

Steps:

• After that, go to the Home tab >> click on Cells >> click on Insert >> select Insert Sheet Rows from the drop-down.

• Next, three new rows will be inserted as we selected four rows previously.
• You can increase as many rows as you like.

Read More: How to Insert Multiple Rows in Excel

### 2. Add Row Within a Cell Using Mouse Shortcut in Excel

You can also add single or multiple rows by rightâ€“clicking on your mouse in Excel.

#### 2.1 Insert Single Row

Here, you will find the steps to insert a single row within a cell using mouse shortcut.

Steps:

• Firstly, select any cell and then click the right button on the mouse.
• Next, you will see a Popâ€“Up.
• Then, select Insert from the Popâ€“Up.

• Now, the Insert box will open.
• After that, select Entire row.
• Lastly, click on OK.

• Finally, you will see a new row added.

#### 2.2 Add Multiple Rows Within a Cell

You can also add multiple rows in the following way.

Steps:

• In the beginning, select the required number of cells. Here, we selected two cells.
• Then, click the right button on the mouse.
• Next, select Insert.

• After that, you will get another Popâ€“Up.
• Now, select the Entire row from the Popâ€“Up.
• Lastly, click OK.

• Finally, you will see 2 new rows added.

### 3. Insert a Row Applying Keyboard Shortcut Within a Cell

In the final method, we will show you how you can insert a row within a cell using a Keyboard Shortcut in Excel.

Steps:

• After that, click Ctrl + Shift + = from the keyboard.

• Now, you will see a Popâ€“Up and where you will see Insert options.
• Then, select the Entire row from the Popâ€“Up.
• Next, click on OK.

• Finally, you will see a new row added.

Read More: Shortcut to Insert New Row in Excel

## Practice Section

In the article, you will find an Excel workbook like the image given below to practice on your own.

## Things to Remember

• When you need to insert new rows, be careful about which rows or cells we will insert rows. Sometimes it may be in the wrong position.

## Conclusion

Here we tried to provide all the possible methods to solve the insert row within a cell in Excel. Hope this will help you to solve your problem. Please let us know if there are any more alternatives that we may have missed. And, visit ExcelDemy for many more articles like this. Thank you!

## Related Articles

Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF