How to Insert Multiple Rows in Excel
Jun 20, 2020 ยท 1 minute read
How to Add Rows in Excel.
First Method;
If you want to insert a row in the excel sheet;
1- Select the row.
2- Right-click on the row.
3- Click on the “Insert”.
4- The inserted row will be placed above the selected row.
Second Method;
1- Select the row.
2- Click on the Home tab.
3- Click on the Insert tab.
4- Click on the “Insert Sheet Rows”.
How to Insert Multiple Rows in Excel;
First Method;
If you want to insert multiple rows;
At first you should follow these steps;
For instance, you want to insert 5 rows above row number 7.
1- Select the rows number 7, 8, 9, 10, 11.
2- Click on the Home tab.
3- Click on the “Insert Sheet Rows”.
Second Method;
1- Select the rows number 7, 8, 9, 10, 11.
2- Right-click on the selected rows.
3- Click Insert key.
