Insert multiple rows

You can add multiple rows to a spreadsheet simultaneously.

Procedure

  1. Open a spreadsheet.
  2. Click the row above which you want to insert rows.
  3. Click the down arrow next to Insert cells Insert cells.
  4. Click Insert cells Insert cells. The dialog opens.
  5. Enter the number of rows and click OK.

The new rows are inserted above the marked row.