How to Get more rows in Excel

How to Insert Multiple Rows in Microsoft Excel Mahesh Makvana @maheshhari November 23, 2021, 11:00am EDT Inserting multiple rows into your Microsoft Excel spreadsheet i

How to Get more rows in Excel

How to Insert Multiple Rows in Microsoft Excel

  • Mahesh Makvana

@maheshhari

  • November 23, 2021, 11:00am EDT
Microsoft Excel logo on a green background

Inserting multiple rows into your Microsoft Excel spreadsheet isnt difficult. Simply use a quick context menu option or a keyboard shortcut to add several rows at once. Well show you how to do just that.

RELATED: How to Quickly Add Rows and Columns to a Table in Microsoft Word

Table of Contents

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

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

One way to add multiple rows in Excel is by using an option in Excels context menu.

To use this method, first, open your spreadsheet with Microsoft Excel.Advertisement

In your spreadsheet, select the number of rows that youd like to add. For example, if you want to add four 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 menu that opens, select Insert.

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

You will see a small Insert box on your screen. In this box, enable the Entire Row option and click OK.

The Best Tech Newsletter Anywhere

Join 425,000 subscribers and get a daily digest of features, articles, news, and trivia. Sign Me Up! We've got your info - thanks for signing up! We were unable to subscribe you! Please check your e-mail address or contact us for assistance. Signing you up...

By submitting your email, you agree to the Terms of Use and Privacy Policy.

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

Advertisement

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

Tip:
New rows added in Excel.

Youre all set.

Insert Multiple Rows in Excel With a Keyboard Shortcut

If you prefer using Excel keyboard shortcuts, theres a shortcut you can use to quickly add multiple rows to your Excel spreadsheet.

RELATED: All the Best Microsoft Excel Keyboard Shortcuts

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

In the spreadsheet, select the number of rows youd like to add. For example, if you want to add three new rows, select three rows in your current spreadsheet. Excel will add new rows above the selected rows.

Select rows in Excel.

While the rows are selected, press Ctrl+Shift+Plus (+ sign) at the same time 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.

Advertisement

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

Rows added to Excel.

And thats how you make room for new data in your spreadsheets by adding multiple rows at once. Very useful!


If you often work with tables, you can add 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

Mahesh Makvana

Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. Hes written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips. Read Full Bio »

Video liên quan