Alok Paul
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:
- To start with, select the required 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.
- 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.
Similar Readings
- How to Insert Rows in Excel Automatically
- How to Insert Multiple Rows After Every Other Row in Excel
- Excel Formula to Insert Rows Between Data
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:
- To start with, select any cell.
- 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.
Download Practice Workbook
Download this practice sheet to exercise while you are reading this article.
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
- How to Insert Row Below in Excel
- How to Insert Blank Row After Every Nth Row in Excel
- How to Insert a Total Row in Excel
- How to Insert Multiple Blank Rows in Excel
- Cannot Insert Row in Excel
- Excel Fix: Insert Row Option Greyed Out in Excel
- VBA to Insert Row in Excel
- Excel VBA: Insert Row with Values
- Insert Rows in Excel Based on Cell Value with VBA
- VBA Macro to Insert Row in Excel Based on Criteria
- Excel Macro to Add Row to Bottom of a Table
- Macro to Insert Multiple Rows in Excel
- Macro to Insert Row and Copy Formula in Excel
