How to Add a Row in Google Sheets | Scribe

    How to Add a Row in Google Sheets

    • Alai Umerez |
    • 17 steps |
    • 31 seconds

      How to Add a Single Row Using the Right Click

      1
      Select a row by clicking on its number on the left-hand side
      2
      With the desired row selected, right-click to open a context menu In the menu, click the option "Insert 1 row above" or "Insert 1 row below" according to your preferences
      3
      Review the results

      How to Add a Single Row Using Menu Features

      4
      Select a row by clicking on its number on the left-hand side
      5
      With the desired row selected, click "Insert"
      6
      From the drop-down menu, select "Rows"
      7
      Click the option "Insert 1 row above" or "Insert 1 row below" according to your preferences

      How to Add Multiple Rows Using the Right Click

      8
      To insert multiple rows, highlight the same number of existing rows, columns, or cells you wish to add - On **Mac**, hold **⌘** and click the rows to select them - On **Windows**, hold **Ctrl** and click the rows
      9
      After selecting the items, right-click anywhere within the highlighted area In the menu, click the option "Insert (x number) rows above" or "Insert (x number) rows below" according to your preferences

      How to Add Multiple Rows Using Menu Features

      10
      To insert multiple rows, highlight the same number of existing rows, columns, or cells you wish to add - On **Mac**, hold **⌘** and click the rows to select them - On **Windows**, hold **Ctrl** and click the rows
      11
      With the desired rows selected, click "Insert"
      12
      From the drop-down menu, select "Rows"
      13
      Click the option "Insert (x number) rows above" or "Insert (x number) rows below" according to your preferences

      How to Add 100 or More Rows

      14
      Navigate to the bottom of your spreadsheet
      15
      At the bottom of the sheet, look for the field labeled “more rows at the bottom”