Microsoft Excel logo on a green background

Inserting multiple rows into your Microsoft Excel spreadsheet isn't hard. Simply use a quick context carte du jour pick or a keyboard shortcut to add together several rows at once. We'll show you how to practise merely that.

RELATED: How to Rapidly Add together Rows and Columns to a Tabular array in Microsoft Word

Insert Multiple Rows in Excel With a Right-Click Menu Option

One style to add together multiple rows in Excel is past using an option in Excel'south context bill of fare.

To utilise this method, beginning, open your spreadsheet with Microsoft Excel.

In your spreadsheet, select the number of rows that you'd like to add. For example, if y'all want to add 4 new rows, select four rows in your spreadsheet above which the new rows will be added.

Select rows in Excel.

Right-click one of the selected rows, and from the carte that opens, select "Insert."

Right-click a selected row and choose "Insert" from the menu in Excel.

You will run into a pocket-sized "Insert" box on your screen. In this box, enable the "Entire Row" choice and click "OK."

Enable "Entire Row" and click "OK" in the "Insert" box in Excel.

And instantly, Excel will add the specified number of rows to your spreadsheet.

Tip: To speedily remove the newly added rows, press Ctrl+Z on PC or Command+Z on a Mac.

New rows added in Excel.

You're all set.

Insert Multiple Rows in Excel With a Keyboard Shortcut

If you lot adopt using Excel keyboard shortcuts, in that location's a shortcut you tin use to quickly add multiple rows to your Excel spreadsheet.

RELATED: All the All-time Microsoft Excel Keyboard Shortcuts

To use the shortcut, beginning, open your spreadsheet with Microsoft Excel.

In the spreadsheet, select the number of rows you'd like to add. For example, if y'all want to add together three new rows, select 3 rows in your current spreadsheet. Excel volition add new rows above the selected rows.

Select rows in Excel.

While the rows are selected, press Ctrl+Shift+Plus (+ sign) at the same fourth dimension on a PC, or Command+Shift+Plus (+ sign) on a Mac. This will open an "Insert" box. In this box, choose "Entire Row" and click "OK."

Select "Entire Row" and click "OK" in the "Insert" box in Excel.

Excel will add the selected number of rows to your spreadsheet.

Rows added to Excel.

And that's how you make room for new data in your spreadsheets by adding multiple rows at one time. Very useful!

If yous ofttimes work with tables, you lot tin add together and remove columns and rows in a table in Excel just as easily.

RELATED: How to Add or Delete Columns and Rows in a Table in Microsoft Excel

The above article may contain chapter links, which help support How-To Geek.