How to Add Multiple Rows Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to insert multiple rows at once in Excel.

Quick summary

Adding multiple rows in Microsoft Excel takes just seconds by selecting the exact number of rows you need and using the right-click Insert command. This method lets you insert several blank rows at a specific position without manually repeating the action.

Steps

Select row 9 (one row below where you want the new rows to appear).
Drag the selection three rows down — check the small count window to confirm the number of rows selected.
Right-click the selected rows and choose "Insert" to add the rows.
Three blank rows will be inserted immediately below row 8.

📌 Why this matters

Knowing how to insert multiple rows in Microsoft Excel at once is a foundational spreadsheet skill that saves significant time compared to adding rows one by one. This feature is essential for anyone managing large datasets, financial models, or structured tables where new data needs to be added without disrupting existing content. By selecting a range of rows and using the right-click Insert method, users can instantly create the exact number of blank rows they need at a precise location. Mastering this technique improves Excel efficiency and reduces repetitive manual work across everyday data management tasks.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel