Time to time we forget to add up the data into tables and in that case, we need to add data or even complete rows of data between the rows of excel sheet. In situations like these Excel provides numerous useful features for it user. Using which you can insert one row or even multiple rows above or below the selected row. Excel offers multiple methods for How add a row in excel. We will be discussing them here one by one.

How to add row in excel using Mouse?

This feature is available in all versions of excel from 2016 to 2019 and even the later version of excel. This is available for Mac and Windows users. Even Linux users can also avail this feature very easily. How can you do this? Let's see the steps down.

1. Look at the vertical just to the left of excel showing row numbers. Simply Right click on row (Where you need to add the row). A menu bar would appear here with certain options.

2. Select Insert row above or Insert Row Below.

3. Your row would be inserted. This feature is useful when you need to add a row simply and don’t want to go for remembering the shortcuts and are in hurry of task completion. This feature is a handy too for that time.

How to add multiple rows in excel using Mouse?

This feature is also available in all versions of excel from 2016 to 2019 and even the later version of excel. This is available for Mac and Windows users. Even Linux users can also avail this feature very easily. How can you do this? Let's see the steps down.

1. Look at the vertical just to the left of excel showing row numbers. Simply select the number of rows above or below which you need to add rows.

2. Right click (Where you need to add the row). A menu bar would appear here with certain options.

3. Select Insert row above or Insert Row Below and mention the number of rows you want to add.

4. Your row would be inserted. This feature is useful when you need to add multiple rows simply and don’t want to go for remembering the shortcuts and are in hurry of task completion. This feature is a handy too for that time.

How to add row in excel using Ribbon tab?

This is also a very useful feature for adding rows in Excel. For this you need navigate through the Ribbon tab and select the required option.

1. For this you need to select the row above or below which you need to add the row in Excel.

2. Select Home tab from ribbon tab and “navigate to rows and columns”.  click there.

3. Select Insert Cell. Here you select any option of your choice according to need.

So, what are you waiting for? Start using this amazing feature from now. If you want to know more about Word features, you can follow WPS Academy to learn.

You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience. You can visit the website to download WPS Office: wps.com