How to Insert a Specific Number of Rows in Excel Quickly

To insert a specific number of rows in Excel for Microsoft 365 on Windows, select the same number of row headers as the rows you need, right-click the selection, and choose Insert. Excel adds that many blank rows above the selected rows. For example, select five row numbers to insert five rows. You can also use the Home ribbon or a keyboard shortcut.

Before starting, decide where the new rows should go and whether you need full worksheet rows or only rows inside an Excel table. Inserting rows shifts existing content down, so save your workbook first if the change could affect important data or formulas.

What You’ll Need

An Excel workbook that you can edit, open in Excel for Microsoft 365 on Windows.
The number of blank rows you want to add and the position where they should appear.
If the workbook is important, a saved copy or a recent saved version you can return to.

Step-by-Step

Find the insertion point. Locate the row that should come immediately after the new blank rows. Excel inserts rows above the row headers you select. If you want four rows between current rows 8 and 9, select row 9. If you want rows at the top of the sheet, select row 1.
Select the number of row headers you need. Click the number at the left edge of the first row where the new rows should begin, then drag down across the required number of row numbers. For instance, to add four rows above row 9, select the row headers 9, 10, 11, and 12. The selected area should be shaded across the worksheet. Make sure you select the gray row-number labels, not just cells in the grid.
Check the selection before inserting. Count the highlighted row numbers. The number selected determines how many rows Excel adds; it does not depend on how many cells contain data. If you need 20 rows, select 20 row headers. A large selection can extend below the visible area, so scroll while dragging or use the Name Box to navigate if necessary.
Insert the rows with the context menu. Right-click one of the selected row numbers and choose Insert. Excel adds the same number of blank worksheet rows above the first selected row. The existing rows and their contents move down. Click a cell in the sheet afterward to remove the row-header selection and inspect the new space.
Use the ribbon instead if you prefer. Keep the row headers selected, then choose Home > Insert > Insert Sheet Rows. The result is the same as using the right-click menu. Choose Insert Sheet Rows, rather than inserting cells, so that each new row spans the worksheet and your columns stay aligned.
Use a keyboard shortcut for a quick insertion. With the required row headers selected, press Ctrl+Shift+Plus (+) on Windows. On some keyboards, the plus sign requires pressing Shift and the equals key. Selecting complete row headers first helps Excel insert whole rows without opening a choice between shifting cells down and inserting an entire row. If the shortcut behaves differently on your keyboard, use the ribbon method.
Confirm the layout and save. Check that the correct number of blank rows appeared in the intended position and that nearby data moved down as expected. Review formulas, formatting, filters, and print layout if the worksheet uses them. Save the workbook when the result is correct.

Example: Suppose your list has headings in row 1 and the first record in row 2. To add three blank records above the current record in row 7, select row headers 7, 8, and 9, then choose Insert. Excel creates three rows above row 7; the old row 7 and everything below it move down three rows. You do not need to select three cells in each column.

If you only want to add rows within an Excel table, rather than insert full worksheet rows, select the same number of table rows at the intended location, right-click, and choose Insert > Table Rows Above when that option is available. Table-specific insertion keeps the new rows within the table structure and can extend its formatting and calculated columns. Check the context menu wording in your Excel build before proceeding.

Common Mistakes

Selecting cells instead of row headers. If you highlight cells such as B9:D12 and choose Insert, Excel may show an Insert dialog and shift only part of the worksheet. That can separate data across columns. For complete worksheet rows, click the row numbers at the left and select the required count.
Selecting the wrong number of rows. Selecting four row headers inserts four rows, even if you intended five. Count the highlighted labels before choosing Insert. The range of row numbers you select is not the number of rows after insertion; it is the number Excel adds.
Choosing the wrong starting row. Excel inserts above the selection. If you select row 8 to add rows after row 8, the new rows will instead appear before it. Select row 9 to place them between rows 8 and 9.
Inserting worksheet rows when you meant table rows. Full worksheet rows affect every column on the sheet and can shift content outside a table. If the goal is to expand a table while leaving unrelated sheet areas in place, use the table-row insertion option instead.
Assuming the change is harmless to every formula or layout. Excel usually adjusts many references when rows are inserted, but workbook structures, external links, named ranges, charts, and manually arranged print areas can behave in ways that need review. Check important calculations and presentation after inserting.
Trying to insert below the final worksheet row. A worksheet has a fixed row limit of 1,048,576. If there is no space at the bottom to shift existing rows down, Excel cannot add more rows there. Remove unused rows or columns near the sheet boundary, or reorganize the data in another worksheet.

Tips

Use a repeatable counting method. For a small number, count the row labels as you drag. For a larger number, select a clearly defined block and verify its endpoints. For example, rows 25 through 34 inclusive contain 10 rows, because both endpoints count.
Navigate directly to the starting row. The Name Box is the small box to the left of the formula bar that normally displays a cell reference such as A1. Type a row reference such as A500 and press Enter to jump near that location, then select the appropriate row headers. This is useful when the insertion point is far down the worksheet.
Use Undo immediately if the wrong count was inserted. Press Ctrl+Z on Windows to reverse the insertion, then make the correct selection and try again. If you have made additional changes since then, review the Undo history before reversing anything.
Expect formatting to follow nearby rows. New worksheet rows often inherit formatting from the rows around the insertion point. If the blank rows have an unexpected color, border, number format, or height, apply the desired formatting after insertion. In a table, table styles and calculated columns may fill automatically.
Protect important work first. Save a copy before inserting a large block into a complex workbook. This is particularly useful if the sheet contains linked formulas, merged cells, a dashboard, or a carefully arranged print layout.
On Mac or Excel for the web, use the visible command if the shortcut differs. The ribbon layout and keyboard shortcuts can vary by platform, keyboard, or browser. Select the row headers and use the available Insert command; in desktop Excel, look under Home > Insert. This avoids relying on a shortcut that may be mapped differently.

Troubleshooting

The Insert option is unavailable or Excel will not change the sheet. Check whether the worksheet is protected. If you have permission, choose Review > Unprotect Sheet and enter a password if prompted. A protected sheet may allow some actions but block inserting rows. Shared-workbook permissions or read-only access can also prevent edits; check the title bar and ask the file owner for edit access if needed.
The rows appeared in the wrong place. Use Ctrl+Z immediately, then identify the row that should follow the blank space. Select that row and the number of row headers matching the number of rows required. Remember that Excel inserts above the selected range, not below it.
Only some columns moved, or an Insert dialog appeared. You likely selected cells rather than complete row headers. Undo the change, click the row numbers on the left, select the full set of rows, and insert again. This ensures the whole worksheet shifts together.
Excel reports that it cannot insert more cells. The worksheet may contain formatting or other content near its bottom or right edge, leaving no room for inserted rows to shift. Save a copy, inspect the area below your data, and remove genuinely unused rows or columns if appropriate. Be cautious: clearing contents is not always the same as deleting rows, and deleting cells can affect references and layout.
The new rows do not match the formatting you expected. Select the inserted rows and apply a suitable number format, fill, borders, or row height from the Home tab. If the rows belong in a table, confirm that you inserted table rows rather than ordinary sheet rows. Check whether formatting rules or table styles are controlling their appearance.
Formulas, filters, or print pages look different afterward. Insertion can change ranges and page breaks. Inspect representative formulas near the insertion point, confirm the filter still covers the intended data, and use Page Layout > Print Area or page-break controls if the printed output matters. If results are wrong, undo the insertion and check the workbook’s structure before trying again.

Frequently Asked Questions

How do I insert 10 rows in Excel at once?

Select 10 row headers where the new space should begin, right-click the selection, and choose Insert. Excel inserts 10 blank rows above the first selected row. Verify that exactly 10 row numbers are highlighted before inserting.

Can I insert rows below a selected row?

Excel inserts rows above the selected row headers. To place new rows below row 12, select row 13 and insert the required number. If row 13 already contains data, that data shifts down to make room.

Can I insert multiple rows without using the mouse?

Yes. Select the row headers using the keyboard, then use the Windows shortcut Ctrl+Shift+Plus (+). You can also use the Name Box to go to a location and choose Home > Insert > Insert Sheet Rows. Shortcut behavior can depend on your keyboard layout.

Will inserting rows change my formulas?

Excel adjusts many cell references when rows are inserted, but you should not assume every workbook feature will update exactly as intended. Review formulas near the insertion point, along with named ranges, charts, external links, and any summaries that depend on a fixed range.

How do I add rows to an Excel table without changing the rest of the sheet?

Select the intended table rows, right-click, and use Insert > Table Rows Above if that option appears. This adds rows to the table rather than inserting entire worksheet rows, helping keep unrelated cells in place. Check the table range and calculated columns afterward.

Does this method work in Excel for Mac and Excel for the web?

The row-header selection method is available in desktop Excel for Mac and Excel for the web, though menus and shortcuts can differ. Select the number of row headers you need and use the available Insert command. On Mac or in a browser, the ribbon or context menu is a reliable alternative when a Windows shortcut does not apply.

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.