HomeApplicationOffice information

How to Hide Rows on Google Sheets on PC or Mac

Steps

  1. How to Hide Rows on Google Sheets on PC or Mac Picture 1
    Open Google Sheets in your internet browser. Type sheets.google.com in your browser's address bar, and hit ↵ Enter or ⏎ Return on your keyboard.
    1. If you're not automatically signed in to Google, enter your email and password to log in.
  2. How to Hide Rows on Google Sheets on PC or Mac Picture 2
    Click a spreadsheet. Find the spreadsheet you want to edit in the list of all your saved sheets, and open it.
  3. How to Hide Rows on Google Sheets on PC or Mac Picture 3
    Click the number label next to the row you want to hide. Find the number label on the left-hand side of the row you want to hide, and click it. This will select and highlight the entire row.
    1. If you want to hide multiple rows at once, hold down the ⇧ Shift key on your keyboard, and then click another row. This will select and highlight all the rows in the selected range.
  4. How to Hide Rows on Google Sheets on PC or Mac Picture 4
    Right-click the highlighted row. This will open your right-click menu in a drop-down box.
  5. How to Hide Rows on Google Sheets on PC or Mac Picture 5
    Select Hide row on the menu. This will collapse and hide the selected row from your spreadsheet. The data in it will not be deleted, but it won't show up on the sheet unless you unhide it.
    1. If you've selected multiple rows, this option will read as Hide rows and indicate the range of selected cells.
4 ★ | 13 Vote
rowclickhideselected

You should read it

May be interested

Office information