WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to insert multiple rows in Excel

July 31, 2023
8.4K Views

We occasionally need to add several rows of tables simultaneously. This method of adding lines one after the other could be more efficient. How to more easily insert multiple rows in Excel is a common question. You will discover numerous techniques in this article for rapidly entering multiple rows in Excel.

Part 1: Inserting Multiple Rows:

In this article’s first section, we analyze how to insert multiple rows in Excel using the Insert Keyword.

Step 1: Open Microsoft Excel

Step 2: Choose the cell to which you wish to insert more rows. You can choose a cell by Shift and Spacebar Key. The number in the left-hand row can also be chosen by clicking.

In the below image,  I choose cell 8, and I want to add three rows below cell 8.

Step 3: Control + Plus or Control + Shift + Plus is a shortcut. You can input the desired number of rows in this manner in which you wish to add multiple rows. You can see the image below; pressing shortcut keys will add one row to the cell.

Step 4: Using this procedure, you can raise a row just above the chosen row. By hitting F4, you can do this process again.

You can customize the number of rows you inserted in the Excel. Below is the image. You can customize by selecting the option represented by red squares.

The row you’re inserting does not affect existing data; as you can see before inserting the rows, the data of Cells 9,10, and 11 are moving after three rows were inserted without disturbing other data.

So, this is the best practice for inserting rows in Excel with Insert Keyword.

Part 2: Inserting Multiple Rows With Data In Excel

In this part, we will discuss inserting multiple rows with data in Excel using the Insert Keyword.

Step 1: Open Microsoft Excel

Step 2: Choose the cell to which you wish to insert more rows. You can choose a cell by Shift and Spacebar Key. In the below image, I choose cell 8, and I want to add three rows below cell 8.

So the method to insert three rows below cell eight is that after selecting cell 8, Press and Hold your mouse left button and select three rows below cell 8. Below is the image.

Step 3: Right-click the three selecting rows; it shows you the options. In these options, Select the insert option to add multiple rows. Below is the image.

Step 4: After selecting the insert option, you can see that it will insert three rows below cell 8. Here is the resulting image. As you can see, it will add three multiple rows below cell 8.

Step 5: To select and add the rows to the computation box, use Alt + I + R, a helpful shortcut.

One of the simplest Excel operations typically completed with a mouse click is copying formulas. I say “usually” because some very unique situations call for exceptional techniques, such as duplicating a set of formulas without altering the cell references or inserting the same formula in several non-adjacent cells.

Fortunately, there are numerous ways to complete the same operation with Microsoft Excel, which is valid for copying formulas.

How To Duplicate A Formula Down A Column:

A formula can be quickly copied along a column in Microsoft Excel. Carry out the following:

  • In the top cell, enter a formula. The image is shown below with a red square.

  • Hover the mouse cursor on the Fill handle, a tiny square in the cell’s lower right corner, after choosing the cell with the formula. The pointer will turn to a substantial black cross as you do this. Below is the image.

  • Holding the fill handle down the column while moving it over the cells you want to copy the formula to, drag it down. Here is the resulting image:

How To Use Excel’s Fill Handle To Insert Consecutive Data In Multiple Rows:

  • The cell containing the first date should be chosen. To fill neighboring cells with sequential dates, drag the fill handle across them. Here is the image below.

  • Choose the fill handle. Hold down the fill handle in the cell’s lower-right corner to fill the remaining series while dragging. A spreadsheet’s fill handles can be moved across, up, or down. Here is the image below.

Now you can see the fill handle automatically fills the data. The image below shows this thing.

Part 3: Advanced Techniques For Inserting Rows

  • Insert multiple rows with the same data in Excel

Following are the steps for this.

Step 1: Select data with the same departments as the employee. Below is the image.

Step 2: Press the Control Ctrl keyword and click on the same department columns. Below is the image. As you can see, this will highlight the columns with the same employee department.

Step 3: Write IT on the last Luna Lu column, and it will enter IT in all the selected fields. Below is the image:

Step 4: You need to press the Ctrl+Enter keyword after writing IT. Below is the resulting image. As you can see, it writes IT in all the selected cells.

  • Insert alternating blank in a dataset.

The following ways exist to insert blank and filled rows in an Excel Dataset.

Step 1: Select the data to which you want to add rows.

Step 2: Right-click and Click on Insert Keyword.

Step 3: It will add a blank row in the Sheet.

  • Use macros to automate the process of inserting rows

          Macro is a very straightforward and user-friendly Excel tool that provides the number of rows in seconds. As you can see, both techniques are simple and quick to complete. To arrange the work, you’ll need rows. Those interested in knowing more about this tool can access the Excel insert multiple rows guide.

Step 1: Obtain the macro code to activate the cells in the Excel spreadsheet.

Step 2: Choose the source to add the rows and run the Macro. The Macro inserts the indicated number of rows.

Step 3: Select the data for the macros

Step 4: Go to View->Macros-> record Macro

Step 5: Click on Ok to record Macro

Step 6: Go to VBA (Microsoft Visual Basic for Application) to create a Macro code

Step 7: You will see a new window so that you can write code in it. When the code is completed, you will run using the F5 button.

Step 8: Stop the record macro, and your task is completed.

Part 4: Best Alternative – Wps

The best alternative for inserting rows is WPS. WPS stands for Writer Presentation Spreadsheet Office. A complete office suite, WPS Office comes with word processing, spreadsheet capabilities, and a presentation maker. It is well known for its free templates and suitability with Microsoft Office.

These templates cover various applications, including resumes, invitations, and formal corporate presentations. They give users access to pre-made editable formats that make creating different types of documents much more straightforward.

Visit the Template Store from the WPS Office program for more template options. To discover a template that meets your needs, select “Template” from the main interface, then “More Templates,” and then look through the categories.

These different templates are available for download and can be used for several activities, simplifying and improving the look of your work. Below is the look of the WPS office.

Advantages of WPS:

There are the following advantages of WPS Office nowadays.

  • Documentation: WPS provides an extensive range of documents where you can do your assignments easily by downloading them to your computer.

  • Design: WPS provides brilliant features and design templates that one can use to make documents and presentations.

  • Presentation Making: You can make excellent presentations using WPS. WPS offers a more significant number of templates for presentations.

  • Easy Access to Templates: You can access the templates easily. You need to download WPS on your laptop.

  • Free Dark Mode: It also provides accessible dark mode. Its dark mode is eye-catching. Many people say that it provides fantastic things for free.

FAQS

  • How to add an in-between row bows multiple times in Excel

Step 1: Select the data to which you want to add rows.

Step 2: Right-click and Click on Insert Keyword.

Step 3: It will add a row in the Sheet.

  • How to compare two Excel sheets and highlight the differences

If your boss demands that you immediately identify the differences between the two Excel sheets, you can use the View Side-by-Side comparison tool.

It would not be a suitable approach if you were dealing with a lot of data. We can easily highlight the various numbers on two Excel sheets using conditional formatting.

Two sheets from separate workbooks cannot be compared using this method. As a result, we must combine Books 1 and 2 into a single workbook.

The following steps can be used to compare them to each other:

Step 1:Choose the values in the table to draw attention to the disparities; in this case, we have chosen the information from sheet 2.

Step 2:Select Conditional Formatting from the Home tab, then click Add New Rule.

Step 3:To choose which cells to format, click Use a Formula in the Select a rule type dialogue box.

After that, click Ok to see the difference between these.

How to lock a row in excel, please browse related articles

Conclusion

In conclusion, this article now teaches you about adding multiple rows in different ways. All the images and steps are added in detail. for you to quickly comprehend how to add multiple rows in Excel; it tells four different ways to add multiple rows in MS Excel.

Once you can go through the article, you’ll have a complete understanding of using Excel in this way. To summarize, WPS Office is a complete office suite; WPS Office comes with word processing, spreadsheet capabilities, and a presentation maker. It is well known for its free templates and suitability with Microsoft Office. It offers many features so everyone can make their presentations and documents easily.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.