Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • Gmail
    • Productivity
      • Time Management
      • Task Automation
    Inside The Web
    Home»Excel»How to Insert Multiple Rows in Excel

    How to Insert Multiple Rows in Excel

    AsmiBy AsmiFebruary 5, 2023 Excel 3 Mins Read

    Excel has made it easier to fill in the information you could’ve missed during data entry. If you’ve missed a row while inserting data in a table or sheet, you can add a new row using CTRL +SHIFT + ‘+’, or if your keyboard has a number pad, use CTRL + ‘+’.

    However, there are instances where you could’ve missed multiple entries. In such cases, adding rows individually can be time-consuming.

    Select an Equal Number of Rows

    Excel inserts rows depending on the number of rows you have selected.

    Excel table

    In this example, we’ve prepared a grocery list. Let’s assume the data is arranged according to its priority. During data analysis, we realized we missed 6 items before Oil. Here’s how we add six more rows before row 8 (Oil).

    1. Select row 8, the row we wish to insert blank rows above.
      Select row Excel
    2. Hold down the SHIFT key then, make a downward selection equal to the number of rows you want to insert (rows 9, 10, 11, 12, and 13).
      Select Excel rows Excel
    3. To add rows, either:
    •  Use the shortcut: CTRL +SHIFT + ‘+’
    •  Navigate through the Home ribbon and select Insert.
      Insert Rows Excel

    Add Multiple Rows After Each Entry

    In some scenarios, you may need to add multiple rows after a certain entry. While the easier way would be to leave room for these data while entering your data, you can still create these changes later. You can still apply the above-mentioned method to add the columns, but we have a method that could get the job done more quickly.

    Use the first method to make your first set of row-entry. To add multiple rows again, select the equal number of rows you wish to insert above the selected row. On your keyboard, hit F4. This will replicate your last action and insert the rows above the first selection. 

    Add multiple rows after a certain row Excel

    For instance, in this table, we need to insert three rows after every three entries. Following the first method, we selected the row we intended to add the rows above of then held SHIFT to select two more rows. After we use CTRL +SHIFT + ‘+’, three blank rows appeared in rows 5, 6, and 7.

    Add multiple rows fast in Excel

    Now, we must replicate this for the next three entries. We selected rows 11, 12, and 13 and then use F4 to insert three rows above them.

    Insert One Row After Multiple Entries

    Does your table need to have an empty space after every record you make in the table? You could be leaving space for an entry that is yet to be calculated, or you could just like the looks of it.

    The methods we mentioned above are a great fit for when you wish to add multiple rows between rows. But, to add multiple, individual rows after each entry, you will have to apply a completely different method.

    1. Select the first row in the grid.
    2. Hold down the CTRL key and select the remaining rows.
      Select Rows
    3. Use CTRL + SHIFT + ‘+’ or, navigate to Home > Insert.
    4. In the pop-up, choose Entire row > OK.
      Insert Entire Row Excel

    Excel will insert an empty row above each selected cell. From what we’ve gathered, if you’ve converted your data to a table, you cannot use this method if you select the entire sheet row. Instead, only select the cells that follow under the table row for this method to work just as fine.

    Multiple individual rows Excel
    Excel Basics
    Asmi

      Asmi is a content writer specializing in MS Office. She loves writing Excel-related content to assist other users to learn their way around the program. She started using Excel when she first entered the industry as a marketing intern. Soon, she realized that learning the often-overlooked spreadsheet program was no piece of cake. In her articles, she attempts to brief out complex topics to help beginner to intermediate-level Excel users. Asmi uses Excel for everything, including creating a grocery list to managing her personal finance. She’s a bit dramatic when it comes to the Flash Fill feature; so much so that could write a eulogy out of it. When she’s not working, you’ll find her learning a new recipe, or cleaning up her mess (out of the failed recipe).

      Add A Comment
      Table of Contents
      • Select an Equal Number of Rows
      • Add Multiple Rows After Each Entry
      • Insert One Row After Multiple Entries
      Recent Posts
      • How to Calculate Discount Percentage in Excel
      • How to Create a Progress Bar in Excel
      • What is VSTACK in Excel
      • How to Separate Dates in Excel
      • How to Lock a Cell in Excel Formula
      • Home
      • Privacy Policy
      © 2023 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.