How to Add a Row in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to insert multiple rows into a Microsoft Excel spreadsheet.

Quick summary

Adding rows in Microsoft Excel is done by selecting the target rows, right-clicking the row numbers, and choosing Insert — Excel will add the exact number of rows you highlighted above the selection.

Steps

Open your Excel file and select the row numbers where you want to insert new rows — for example, highlight 10 existing rows to insert 10 new ones.
Right-click on any highlighted row number to open the context menu.
Click Insert from the context menu to add the rows.
Confirm that the new rows have been successfully inserted above your original selection.

📌 Why this matters

Knowing how to quickly insert rows in Microsoft Excel is a fundamental spreadsheet skill that saves time during data entry, reporting, and analysis. Instead of manually shifting data or restructuring a sheet, Excel's built-in Insert feature lets users add multiple rows in seconds by simply selecting and right-clicking. This technique works across all modern versions of Excel and is essential for anyone managing large datasets, financial models, or structured tables. Mastering this workflow reduces errors and keeps spreadsheets organized without disrupting existing formulas or formatting.

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