How to Insert a Row within a Cell in Excel (3 Simple Ways)

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. It is also helpful to learn the various methods and choose the easiest way for you to use and remember. We are going to provide instructions on how to insert a row or more rows within a cell in Excel.

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

Download Practice Workbook

Download this practice sheet to exercise while you are reading this article.

Three Methods to Insert a Row within a Cell

1. Insert a Row Using Ribbon

(a) Using Cell Insert a Row

Here we will describe how to add rows by selecting a Cell.

Step 1:

  • Select one cell within the sheet.
  • Go to Home from the ribbon.
  • Click Insert from the ribbon.
  • Select Insert Sheet Rows from the drop-down.

Using Cell Insert One Row from ribbon options

Step 2:

  • Then we click the Insert Sheet Rows and get a new row.

Using Cell Insert One Row is inserted

(b) Using Row Insert a Row

You can do this by selecting a Row also.

Step 1:

  • Select one row within the sheet.
  • Go to Home from the ribbon.
  • Click Insert from the ribbon.
  • Select Insert Sheet Rows from the drop-down.

Using Row Insert One Row from ribbon options

Step 2:

  • After that, we click the Insert Sheet Rows to get a new row.

Using Row Insert One Row is inserted

Note: When inserting new rows we will see the Insert Options button next to the inserted cells. This button will give the option to choose how Excel formats these cells. By default, Excel formats inserted rows with the same formatting as the cells in the row above. To access more options, click your mouse over the Insert Options button, and then click the drop-down arrow.

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

(c) Insert Multiple Rows within a Cell

Step 1:

  • Select the required number of cells within the sheet.
  • Go to Home from the ribbon.
  • Click Insert from the ribbon.
  • Select Insert Sheet Rows from the drop-down.

Using Cell Insert Multiple Rows from ribbon options

Step 2:

  • We click the Insert Sheet Rows and will see that three rows are inserted here, as we selected three cells.
  • We can select as many cells and increase rows as well.

Using Cell Insert Multiple Rows are inserted

(d) Using Row Insert Multiple Rows

You can also insert multiple rows by selecting rows.

Step 1:

  • Select the required row within the sheet.
  • Go to Home from the ribbon.
  • Click Insert from the ribbon.
  • Select Insert Sheet Rows from the drop-down.

Using Row Insert Multiple Rows from ribbon options

Step 2:

  • Then we click the Insert Sheet Rows and four new rows will insert as we selected four rows previously.
  • We can increase as many rows as we like.

Using Row Insert Multiple Rows are inserted

2. Insert Row with Mouse Shortcut

(a) Insert Single Row

Step 1:

  • Select any cell and then click the right button of the mouse.
  • We will see a Pop-Up.
  • Then select Insert from the Pop-Up.

Insert One Row Using Mouse shortcut method

Step 2:

  • We will get another Pop-Up.
  • Select the Entire row from the Pop-Up.

Using Mouse shortcut insert options

Step 3:

  • Finally, you will see a new row added.

Using Mouse shortcut One Row is inserted

You can also add multiple rows in the following way.

(b) Insert Multiple Rows within a Cell

Step 1:

  • Select the required number of cells and then click the right button of the mouse.
  • We will see a Pop-Up.
  • Select Insert from the Pop-Up. Here we selected two cells.

Insert Multiple Row Using Mouse shortcut options

Step 2:

  • We will get another Pop-Up.
  • Select the Entire row from the Pop-Up.

Multiple Row insert option in Mouse shortcut

Step 3:

  • Finally, you will see 2 new rows added.

Using Mouse shortcut Multiple Rows are inserted

3. Insert a Row Using Keyboard Shortcut within a Cell

Step 1:

  • Select any cell.
  • Click Ctrl + Shift + = from the keyboard.
  • You will see a Pop-Up and where you will see Insert options.

Insert Using Keyboard shortcut

Step 2:

  • We will get another Pop-Up.
  • Select the Entire row from the Pop-Up.
  • Finally, you will see a new row added.

Using Keyboard shortcut one row is inserted

Remember

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

Alok

Hello, this is Alok. I am a Telecom Engineer. I completed my study at East West University. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo