If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.
Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.
If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:
With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.
Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.