How to hide rows in Google Sheets on on a computer or mobile device
- You can easily hide rows in Google Sheets in a few quick steps on a computer or mobile device.
- You can also unhide rows in Google Sheets using the same method.
- Visit Business Insider's homepage for more stories.
You can hide rows in Google Sheets just as easily as in Microsoft Excel and it's a quick process on either a computer or mobile device.
Here's how to do it.
Check out the products mentioned in this article:
iPhone 11 (From $699.99 at Best Buy)
Samsung Galaxy S10 (From $899.99 at Best Buy)
MacBook Pro (From $1,299.99 at Best Buy)
Lenovo IdeaPad (From $299.99 at Best Buy)
How to hide rows in Google Sheets on a computer
1. Open the Google Sheet you want to edit on your Mac or PC.
2. Select the row you want to hide.
3. Right-click the selected row and choose Hide row from the menu that opens. Two arrows will appear in place of the hidden row.
You can unhide the rows by clicking one of the arrows that appeared in place of the hidden row number. The hidden row then will reappear.
How to hide rows in Google Sheets on a mobile device
1. From the Google Sheets app, open the Google Sheets document you want to edit.
2. If you're using an iPhone, simply select the rows you want to hide and tap on them. On the menu that appears, choose "Hide row."
3. The process on an Android is similar. Tap and hold the row you want to hide. On the menu that appears above the selected row, tap the three vertical dots and choose "Hide row."
Unhide the row by repeating the above steps, then choosing Unhide row from the menu.
Apple iPhone 11 Check price at Walmart Check price at Straight Talk 
Samsung Galaxy S10 Check price at Amazon Check price at Walmart Check price at Best Buy 
Apple Macbook Pro 13-Inch Display with Touch Bar Check price at Best Buy Check price at Apple 
Lenovo IdeaPad 130 Check price at Best Buy Check price at Walmart
Related coverage from How To Do Everything: Tech:
How to make a bar graph on Google Sheets in 5 simple steps, to make your spreadsheet data more digestible
How to set a print area in Google Sheets, so you can print selected cells or sheets
How to merge cells in Google Sheets on desktop or mobile, to combine multiple cells into one larger cell
How to add a drop-down list in Google Sheets to group and organize data in your spreadsheet
How to draw in Google Docs using the built-in 'Drawing' tool, to add customized drawings to your documents
Insider Inc. receives a commission when you buy through our links.
ncG1vNJzZmivp6x7o8HSoqWeq6Oeu7S1w56pZ5ufonyowcidnKxnpJqwqXvHqK5mrJ9itaqwxGapqK%2BjYravecaopqCklWLAqbHErao%3D