How to add more than one row or column in MS Excel

Drag to select rows or columns if you want to add rows or columns above or left. Right click the highlighted rows or columns and choose Insert from the drop down menu. New rows is inserted.