Inserting a number of rows into your Microsoft Excel spreadsheet is not troublesome. Merely use a fast context menu choice or keyboard shortcut so as to add a number of traces directly. We’ll present you easy methods to do it.

associated: How one can Rapidly Add Rows and Columns to a Desk in Microsoft Phrase

Insert A number of Rows with Proper-Click on Menu Choice in Excel

One strategy to concatenate a number of rows in Excel is to make use of an choice in Excel’s context menu.

To make use of this technique, first, open your spreadsheet with Microsoft Excel.

In your spreadsheet, choose the variety of rows you need to add. For instance, if you wish to add 4 new rows, choose the 4 rows in your spreadsheet above which the brand new rows will likely be added.

Select Rows in Excel.

Proper-click on one of many chosen rows, and from the menu that opens, choose “Insert”.

You may see a small “Insert” field seem in your display. On this field, allow the “Total row” choice and click on “OK.”

And instantly, Excel will add the desired variety of rows to your spreadsheet.

tip: To rapidly delete newly added rows, press Ctrl+Z on PC or Command+Z on Mac.

New rows added to Excel.

you are all set.

Insert A number of Rows in Excel with One Keyboard Shortcut

In case you desire to make use of Excel keyboard shortcuts, there’s a shortcut you need to use to rapidly add a number of rows to your Excel spreadsheet.

associated: All of the Greatest Microsoft Excel Keyboard Shortcuts

To make use of the shortcut, first, open your spreadsheet with Microsoft Excel.

Within the spreadsheet, choose the variety of rows you need to add. For instance, if you wish to add three new rows, choose three rows in your present spreadsheet. Excel will add new rows on prime of the chosen rows.

Select Rows in Excel.

When the rows are chosen, press Ctrl+Shift+Plus (+ signal) on the similar time on a PC, or Command+Shift+Plus (+ signal) on a Mac. It will open an “Insert” field. On this field, choose “Total row” and click on “OK.”

Excel will add the chosen variety of rows to your spreadsheet.

Rows added to Excel.

And that is the way you make room for brand spanking new information in your spreadsheet by including a number of rows directly. very useful!


In case you work with tables typically, you possibly can add and take away columns and rows in a desk simply as simply in Excel.

associated: How one can add or take away columns and rows in a desk in Microsoft Excel?



Supply hyperlink