How to insert a lot of rows into Google Sheets | Scribe

    How to insert a lot of rows into Google Sheets

    • Lindsey Bly |
    • 9 steps |
    • 19 seconds
    information ordinal icon
    This guide will show you how to insert a single row or multiple rows into a Google Sheet.
    1
    Navigate to your Google Sheet.
    2
    Click here.
    3
    Click on the row number to highlight the whole row.
    4
    Click "Insert 1 row above" to add a single row.
    5
    To add multiple rows at once, click the row number
    6
    Scroll down to the number of rows you want to add and click on that row number. For example, if you're starting at Row 7 and want to add 44 rows, scroll down to row 50.
    7
    Click on that row number. Google Sheets will highlight all the rows in between those two numbers
    8
    Click "Insert X rows above".
    9
    Google sheets will automatically add in new rows.