How to Hide Rows in Google Sheets | Scribe

    How to Hide Rows in Google Sheets

    • 12 steps |
    • 33 seconds
    • Google SheetsGoogle Sheets
    1
    Sign in to your Google account and open a spreadsheet [https://docs.google.com/spreadsheets](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=1564491323#gid=1564491323)
    2
    Select the row you want to hide.
    3
    Right-click on the number next to the row you selected.
    4
    Click “Hide row”
    5
    If you wish to hide more than one row that are contiguous, select the rows clicking on them.
    6
    Right-click on the numbers next to the rows you wish to hide.
    7
    Select “Hide rows x -x”
    8
    If you wish to hide more than one row that are **not** contiguous, select the rows clicking on them while pressing [[Ctrl]] or [[cmd]].
    9
    Right-click on the numbers next to the rows you wish to hide.
    10
    Click “Hide rows”
    11
    Now, all the rows you selected are hidden.
    12
    A pair of arrows will appear on the rows above and below your hidden selection to indicate there are hidden rows. You can show the rows again by clicking on the arrows in the numbers next to each hidden row.