How to Insert Rows in Excel (Step-by-Step Guide)

In Excel, inserting rows is a basic but essential task when you need to expand a dataset, add missing records, or adjust the structure of a worksheet. Whether you are maintaining a simple list or updating a large table, knowing how to insert rows efficiently helps keep your data organized and your workflow uninterrupted.

Although the task itself is straightforward, the method you use can vary depending on what you need to do. For example, you may want to insert a single row, add multiple rows at once, place rows below a specific position, or work within an Excel table without affecting surrounding data. Using the right approach can save time and make worksheet editing more accurate and efficient.

• Add a row in Excel
• Insert multiple rows at once
• Insert a specific number of rows with Kutools for Excel
• Insert rows below in Excel
  • Using the fill handle
  • Using Kutools' Add Below command
  • Using Kutools' Add Rows dialog box
• Insert a row every other row
  • Manually add blank rows at intervals with the Ctrl key
  • Quickly insert blank rows at intervals with Kutools for Excel
• Add multiple rows inside an Excel table
• Frequently Asked Questions

Add a row in Excel

If you only need to insert one blank row, Excel gives you several simple ways to do it. The new row is inserted above the row you select.

1. Select the row underneath the position where you want the new row to appear. You can do this by clicking the row number on the left.
2. Insert the row by using one of these methods:
   • Right-click the selected row and choose Insert.

     

   • Go to the Home tab, click Insert, and then choose Insert Sheet Rows.

     

   • Or press Alt + I (insert), then press R (row).

Excel will place a new blank row above the row you selected.

Note:

After a row is inserted, Excel may automatically apply formatting from the row above or below. If you want to change how the new row is formatted, click the Insert Options button that appears next to the inserted row and select the formatting option you prefer.

Tip: If the Insert Options button isn't visible, go to File > Options > Advanced. Then, in the Cut, copy and paste group, check the Show Insert Options buttons option.

Insert multiple rows at once in Excel

If you want to insert more than one blank row, you can do that in a single action instead of repeating the insert command again and again.

Here’s how to do it:

1. Select the same number of existing rows as the number of blank rows you want to add. For example, if you want to insert 3 new rows, first select 3 rows.
2. Use any one of the following methods: (The screenshot demonstrates the first method)
   • Right-click any selected row and choose Insert.
   • Open the Home tab, click Insert, and select Insert Sheet Rows.
   • Press Alt + I, then press R.

     

The same number of blank rows will be inserted above the rows you selected.

Tip: To insert non-adjacent rows, hold down Ctrl while clicking different row numbers to make multiple selections. Then use any of the row insertion methods above. Excel will insert new rows above each selected row, so the new rows will appear in separate positions rather than as one continuous block.

Insert a specific number of rows with Kutools for Excel

With Excel’s built-in tools, you must first select the same number of rows you want to insert, which can be inconvenient especially when the number is large. Kutools for Excel simplifies this process by letting you specify exactly how many rows to insert in a dialog box. It also gives you the option to add rows either above or below the current selection, which is more flexible than Excel’s default insert behavior.

1. After downloading Kutools for Excel, select the row where you want to insert new rows.
2. Select Add Rows from the right-click menu.

   

3. In the pop-up dialog box, choose whether to insert rows above or below the selection, specify how many rows to add, and click OK.

   

How to insert rows below

By default, Excel inserts new rows above the selected row. To insert one or multiple blank rows below a specific row instead, you can use one of the following methods.

Insert many rows below using Kutools' Add Rows dialog box

Kutools for Excel lets you quickly insert a large number of rows below the selected position by entering the exact number in the Add Rows dialog box, which is especially convenient when you need to insert a very large number of rows, such as 300.

1. Select the row where you want to insert new rows below.
2. Select Add Rows from the right-click menu.

   

3. In the pop-up dialog box, choose Below the selection, specify how many rows to add, and click OK.

   

Insert a row every other row

If you need spacing between records or want to prepare a sheet for manual entry, inserting a blank row every other row can help. You can do this manually or with Kutools.

Frequently Asked Questions

How do I select an entire row in Excel?

Move the pointer over the row number on the left side of the worksheet until it changes to a right-pointing arrow, then click the row number to select the entire row. Once selected, you can insert, delete, or format the row.

Can I select a cell instead of a row to insert a row?

Yes. You can right-click a cell and choose Insert. In the Insert dialog box, select Entire row and click OK. Excel will then insert a new row above the cell’s row.

Why can’t I see the Add Rows or Add Below option in the right-click menu?

The Add Rows and Add Below commands come from Kutools for Excel, not from Excel itself. To make them appear in the right-click menu, install and enable Kutools for Excel.

How do I insert rows in different places instead of one continuous block?

To insert rows in different places, select the row numbers one by one while holding Ctrl. Then right-click any selected row number and choose Insert. Excel will insert a new row(s) above each selected row(s).

Why are adjacent selected rows not inserted as one block?

This usually happens when the rows were selected one by one while holding Ctrl (see Manually add blank rows at intervals with the Ctrl key). Even if those rows are next to each other, Excel still treats them as separate selections. As a result, it inserts a new row above each selected row separately rather than adding all the new rows as one continuous block.

To insert rows as a continuous block, select the rows by dragging across the row numbers, or by clicking the first row, holding Shift, and clicking the last row.

Why can’t I insert rows in Excel?

Excel may prevent row insertion if the worksheet is protected, the cells contain merged areas spanning multiple rows, or the sheet has reached its row limit. Check whether the sheet is protected or if merged cells are blocking the insertion.

Conclusion

If you only need to insert a row occasionally, Excel’s built-in methods such as the right-click menu, the Home tab, and the keyboard shortcut are usually all you need. They are quick, simple, and work well for most everyday tasks.

If you often need to add several rows, insert rows below, or place blank rows at intervals, learning the multi-row methods can save time and reduce repetitive work. For users who handle these tasks regularly, Kutools for Excel can make the process much more convenient.

And if your data is stored in an Excel table, using table-specific row insertion methods helps keep formulas, formatting, and structure consistent as your dataset grows.

I hope you found this tutorial helpful. If you’d like to explore more Excel tips and practical solutions, please click here to browse our full collection of Excel tutorials.