Insert Row in Excel (After Every Row and for Table)

Get FREE Advanced Excel Exercises with Solutions!

In this article, you will learn about how to insert row in Excel. Additionally, you will also know about deleting rows in your Excel Sheet and dataset. You will get to know about some effective keyboard shortcuts to add rows in Excel.

Inserting rows in Excel can seem like a simple task, However, certain approaches and factors might boost your productivity and save you time.

Overview image of insert row excel

Download Practice Workbook

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

How to Insert a Row in Excel

1.    Using Keyboard Shortcut

To insert an entire row in Excel on row 7;

  • Select row 7 and then press ALT+I+R.

A new row has been inserted into your Excel sheet.

Inserting a row using the keyboard shortcut

You can use another keyboard shortcut method-

  • Select row 7 and then press ALT+SHIFT+Plus Sign (+).

In your Excel sheet, a new row has been added.

Using the keyboard shortcut to insert a row 

Another option is to utilize a keyboard shortcut-

  • Select row 7 and then press CTRL+Plus sign in numerical pad(+).

A new row has been added to your Excel sheet.

Using numeric number pad to insert a row

2. Inserting Row Using Insert Dialogue Box

Now we are going to insert an entire row by using the Insert dialogue box.

  • Select the row number where you want to insert it. Select row 8 and click as follows:

Go to Home >> Insert >> Insert Sheet Rows.

Using the insert dialogue box to insert a row

A blank row has been inserted on row 8 in your Excel sheet.

Output image after inserting a row 

3. Inserting Row in Excel If There’s Data to the Right of Your Table

To add a row in the table before row 8,

  • Select cell B8 and click as follows: Go to Home >> Insert >> Insert Table Rows Above.

Inserting a row within a table

Now you can see a new row has been inserted within the table but didn’t affect the data on the right side

Output image after adding a row in the table 

How to Insert Multiple Rows in Excel

1.    Using Keyboard Shortcut

To insert multiple rows in Excel-

  • Select rows 7,8,9 and then press ALT+I+R.
  • You can also use the Shift+Space keyboard shortcut to select the entire rows after selecting any cell from that row.

Inserting multiple rows by using the keyboard shortcut 

Three new rows have been inserted into your Excel sheet.

Image after applying keyboard shortcut

Read More: How to Insert a Total Row in Excel

2. Inserting Rows Using Insert Dialogue Box

To insert multiple rows manually-

  • First, select multiple rows like we have selected 7,8,9.  Then follow the following process:

Home >> Insert >> Insert Sheet Rows.

Inserting multiple rows by using the insert dialogue box

Three new rows have been added to your Excel worksheet.

Image after inserting multiple rows

Read More:

3. Inserting a Blank Row After Every Existing Row

To insert a blank row after every existing row alternatively-

  • Select every row individually by clicking the row number using your mouse without the first row of the table.
  • Then press ALT+I+R.

Selecting every row separately

You can see that blank rows after every existing row has been inserted.

Inserting alternate blank rows

Read More: How to Insert Multiple Blank Rows in Excel

How to Delete Row in Excel

1. Deleting an Entire Row

To delete an entire row from your dataset-

  • Select the row that you want to remove here we have selected row 7 and then go to the Home tab.
  • Click on the Delete Sheet Rows from the drop-down menu.

Selecting Delete Sheet Rows

The result will look like the image below.

After deleting a row from the datasheet

2. Deleting a Row Within a Table

To delete a row from your table-

  • Select the cell that you want to remove here we have selected cell B8 and then go to the Home tab.
  • Click on the Delete Table Rows from the Delete drop-down menu.

Selecting Delete Table Rows

The selected row has been deleted from the table and the table looks like the image below.

Excel table after deleting a row from the table

Things to Remember

  • Select the entire row: Before inserting or deleting a row, make sure you select the entire row. You can do this by clicking on the row number on the left side of the spreadsheet. This ensures that you insert or delete the entire row and not just a portion of it.
  • Inserting rows: When you insert a row, the rows below it move down by one position, along with any data, formatting, formulas, or references in those rows.
  • Deleting rows: When you delete a row, the rows below the deleted row will move up to fill the gap. Any data or formatting in those rows will also move up.
  • Consider hidden rows: If you have hidden rows in your spreadsheet, be aware that inserting or deleting rows may affect the hidden rows.

Frequently Asked Questions

1. Why does Excel not allow to insert row?

Your sheet may have frozen panes, preventing you from inserting rows in Excel. Unfreezing those panes is the answer in that situation to add a new row to the Excel spreadsheet.

2. How many rows are in Excel?

In modern versions of Excel (Excel 2007 and onwards, including Excel 2010, 2013, 2016, 2019, and Excel for Microsoft 365), there are 1,048,576 rows available.

3. Does Excel automatically adjust row height?

When you change the font size for a specific row or rows, Excel automatically makes the row higher or shorter. According to Microsoft, the row height with the default typeface, Calibri 11 is 12.75 points, which is roughly 1/6 inch or 0.4 cm.


In the end, you will get to know a brief idea about how to insert row in Excel. Throughout this article, we explored various aspects of working with rows in Excel. We learned how to insert, delete, and other structures of a worksheet.

I believe you will find this post very useful for your future purposes. If you have any queries, please leave them in the comments section, and don’t forget to check out our Exceldemy website.

Insert Row in Excel: Knowledge Hub

<< 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.
Mizbahul Abedin
Mizbahul Abedin

Md Mizbahul Abedin, BSc, Textile Engineering and Management, Bangladesh University of Textiles, has been working with the ExcelDemy project for 11 months. Currently working as an Excel and VBA Content Developer who provides authentic solutions to different Excel-related problems and writes amazing content articles regularly. He has published almost 20 articles in ExcelDemy. He has passions for learning new things about Microsoft Office Suite and Data analysis. Besides, he also likes to travel, photography, international politics, and read... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF