Insert Row in Excel After Every Row and for Table: 8 Methods

Method 1 – Using Keyboard Shortcut

  • 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 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

Method 2 – Inserting Row Using 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 

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

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

Inserting a row within a table

You can see a new row has been inserted within the table but it 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

Method 4 – Using Keyboard Shortcut

  • 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

Method 5 – Inserting Rows Using Insert Dialogue Box

  • 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

Method 6 – Inserting a Blank Row After Every Existing Row

  • 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

How to Delete Row in Excel

Method 7 – Deleting an Entire Row

  • Select the row that you want to remove. 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

Method 8 – Deleting a Row Within a Table

  • Select the cell you want to remove; we 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.

Download Practice Workbook

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

Insert Row in Excel: Knowledge Hub

<< Go Back to Rows in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
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