Insert Rows in Excel Multiple Times: A Step-by-Step Guide

How-to basics · Updated November 18, 2026

To insert several rows in Excel at once, select the same number of row headers as the number of rows you need, right-click the selection, and choose Insert. Excel adds that many blank rows above the first selected row. To insert rows at different points, work from the bottom of the sheet upward so earlier insertions do not change the row numbers you still need to reach.

The steps below are for Microsoft Excel for Microsoft 365 on Windows. You can use the ribbon or keyboard shortcuts for a quick insertion, and the same basic row-selection approach works in Excel for Mac and Excel for the web. First decide whether the new rows should be together or spread through the worksheet; the best method depends on that.

What You’ll Need

  • An Excel workbook with the worksheet where you want to add rows.
  • For insertions at several separate locations, a list of the original row numbers or clear landmarks, such as the names beside each insertion point.
  • If the sheet contains formulas, tables, filters, or merged cells, a moment to check how those features may respond to inserted rows.

Step-by-Step

  1. Save a copy if the worksheet is important. Row insertion is normally reversible with Ctrl+Z on Windows, but a saved copy gives you a recovery point if the sheet has complicated formulas, formatting, or linked data. On Mac, use Command+Z to undo. If the workbook is shared or stored in the cloud, make sure you are editing the intended file and sheet.
  2. Choose the insertion point. Excel inserts worksheet rows above the row or rows you select. For example, to add blank rows before the current row 8, select row 8. If you need to add rows at the bottom of a list, check whether the list is an Excel table; adding a table row is different from inserting an entire worksheet row.
  3. Insert several consecutive rows in one action. Count how many rows you want to add. If you need four, select four row headers: click the number at the left of the first row where the blanks should appear, then drag down across the next three row numbers. The complete rows should be highlighted. Right-click any highlighted row number and choose Insert. Excel inserts four blank rows above the first selected row. You can also use Home > Insert > Insert Sheet Rows.
  4. Use the keyboard for a faster insertion. Select the needed number of full row headers, then press Ctrl+Shift+= on Windows. Depending on your keyboard layout, you may need to press the plus key, which is usually Ctrl+Shift+Plus. If Excel displays the Insert dialog instead of inserting immediately, choose Entire row and confirm. On a Mac, use the ribbon route Home > Insert > Insert Sheet Rows if the keyboard shortcut differs on your keyboard. In Excel for the web, the ribbon or row-header right-click menu is also a dependable option.
  5. Repeat the action when you need another block in the same area. Select the next row header where the new block belongs, select as many row headers as the number of rows to add, and use the same Insert command. For instance, to add two rows above row 20 and three above row 35, insert the three rows above row 35 first, then insert the two rows above row 20. Working from the lower location upward keeps the upper location at its original row number.
  6. Insert rows at multiple separate locations from bottom to top. Write down the original row numbers or identify the rows by their contents before you begin. If you need blank rows above original rows 6, 14, and 22, start by inserting above row 22, then row 14, then row 6. At each location, select the number of row headers you need and insert. Because you move upward, inserting below a target does not shift the targets that remain. If you instead start at the top, every insertion changes the row numbers below it, which makes it easy to insert in the wrong place.
  7. Check the result and restore anything that needs attention. Confirm that the number of blank rows is correct and that they are above the intended records. Review formulas, totals, formatting, filters, and any charts or references that depend on the changed range. Excel usually adjusts ordinary cell references when rows are inserted, but complex formulas, external links, and manually maintained ranges still deserve a check. If the insertion was misplaced, press Ctrl+Z on Windows or Command+Z on Mac right away, then repeat using the corrected selection.

Example: Suppose your worksheet has a heading in row 1 and data beginning in row 2. To insert three blank rows before the fifth data record, identify that record’s current worksheet row, select that row and the next two row headers, and choose Insert. The blanks appear above the selected area; they do not replace the three records. If you are inserting blocks at several original row numbers, process the largest row number first.

If you need a blank row between every existing record, Excel does not provide a simple one-click command that automatically inserts a row after each selected record in a normal range. You can insert the rows one position at a time, working upward, or use a carefully prepared helper-column-and-sort method. For a small list, the manual bottom-up approach is often easier to verify. For a large dataset, make a copy first and confirm the intended order before using any bulk rearrangement method.

Common Mistakes

  • Selecting cells instead of row headers: If you select cells in the grid and choose Insert, Excel may open a dialog asking whether to shift cells right or down. For whole worksheet rows, click the numbered row headers at the far left and use Insert Sheet Rows.
  • Selecting only one row when you need several: Excel inserts the same number of rows as the number of full row headers selected. Selecting one row and repeating Insert several times can work, but selecting the total number at once is quicker and less error-prone.
  • Inserting at separate locations from top to bottom: Each insertion pushes lower rows down. The row numbers you planned to use can then point to different records. Work from the bottom upward, or recheck each target by its contents before inserting.
  • Confusing worksheet rows with table rows: A formatted Excel table has its own row-insertion behavior. Right-click a cell in the table and look for Insert and the table-row option, such as Table Rows Above. Inserting an entire sheet row affects the whole worksheet, not just the table.
  • Ignoring hidden or filtered rows: A filter can make some records disappear from view, while hidden rows can make selections look different than expected. Clear or review filters and hidden rows before a large insertion so you can verify the actual worksheet positions.

Tips

  • Use the row numbers as your selection target. Click a row number to select a whole row. To select a continuous block, drag across the row headers or click the first header, hold Shift, and click the last header.
  • Match the selection to the number of blanks. Selecting five complete rows and choosing Insert adds five rows. This is more reliable than repeating a single-row insertion many times.
  • Use recognizable landmarks for scattered insertions. Note the text in the row beside each insertion point as well as the row number. If an earlier edit has changed the sheet, the landmark can help you find the right record.
  • Consider how formatting should carry forward. Excel generally copies formatting from surrounding rows, but the result can depend on the selected area and neighboring cells. After insertion, use the small Insert Options button if it appears to choose whether to format like the row above, the row below, or clear formatting.
  • Keep a clean source copy for repeated work. If you regularly add rows to a template or reporting sheet, save a version before the changes. This is especially useful when the workbook contains merged cells, formulas, or several linked worksheets.

Troubleshooting

Excel inserted cells rather than whole rows. Undo the change, then select the row numbers at the left edge of the worksheet. Choose Home > Insert > Insert Sheet Rows rather than inserting from a selection of individual cells. The row-header right-click menu is another clear way to identify the whole-row command.

The new rows appeared in the wrong place. Press Ctrl+Z on Windows or Command+Z on Mac immediately. Find the correct target by checking the row number and the record beside it, then select the full row header above which the blank rows should go. When there are several locations, begin with the lowest one. If you have made other edits since inserting, review the undo sequence before undoing so you do not remove unrelated work.

The Insert command is unavailable or Excel shows an error. Check whether the worksheet is protected. If you have permission, use Review > Unprotect Sheet, then insert the rows; a password-protected sheet requires the password or help from its owner. Also check whether the workbook is in a mode that restricts editing, such as read-only access, and whether a merged-cell layout is interfering with the selected range. If the file is shared, confirm that you have edit permission.

Rows did not appear inside the table. Click a cell in the table and use its row-insertion command, or enter data in the first row immediately below the table to extend it when Excel recognizes the new row. If you want blank worksheet rows across the entire sheet, select the sheet row headers instead. Afterward, check that formulas and table formatting cover the intended records.

Formulas or formatting look different afterward. Insertion often adjusts formulas and inherits nearby formatting, but it cannot guarantee that every workbook-specific reference or style is correct. Compare the affected formulas with adjacent rows, inspect totals and named ranges where relevant, and use the Insert Options control to adjust formatting. If the result is difficult to repair, undo the insertion and try again on a saved copy.

Frequently Asked Questions

How do I insert multiple rows in Excel at once?
Select the same number of full row headers as the number of rows you want, right-click, and choose Insert. The new rows appear above the first selected row.

Can I insert rows in several different places at the same time?
The dependable approach is to insert each block separately, starting at the lowest location and moving upward. This preserves the original row numbers for the targets above.

Will inserting rows delete or overwrite my existing data?
No. Inserting rows shifts existing content downward; it does not replace those records. Still, check the result and save a copy first if the workbook is important.

What is the shortcut to insert rows in Excel?
On Windows, select full row headers and press Ctrl+Shift+= (often entered as Ctrl+Shift+Plus). If the shortcut opens a dialog, choose Entire row. On Mac, use Home > Insert > Insert Sheet Rows if the keyboard shortcut on your layout is different.

How do I add rows to an Excel table?
Right-click a row inside the table and choose the table-row insertion option, such as Table Rows Above. Use whole worksheet row headers only when you want to add rows across the sheet, not just within the table.

Does this work in Excel for the web?
Yes. Select row headers and use the Insert command on the ribbon or the row-header context menu. The exact shortcut can vary by browser and keyboard, so the menu is the safer choice.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.