How do i hide multiple rows in Google Sheets
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. Show
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 computer1. 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. Right click and tap "Hide row." Michelle Greenlee/Business InsiderYou 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 device1. 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." Tap "Hide row" on the menu. Michelle Greenlee/Business Insider3. 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." Unhiding rows on an Android is similar to an iPhone. Michelle Greenlee/Business InsiderUnhide the row by repeating the above steps, then choosing Unhide row from the menu.
Related coverage from How To Do Everything: Tech:
Insider Inc. receives a commission when you buy through our links.
How to Hide Rows and Columns in Google Sheets
You can hide rows and columns in a worksheet from view. Data isn't deleted, but simply hidden until it is unhidden again, which can help you narrow your focus to only on the data needed at the given time. Hide a Row or ColumnYou can hide rows and columns in a spreadsheet in order to cut down on visual clutter.
The column is hidden from view. Nothing is deleted, and its values can still be referenced by formulas, but it won't appear on the spreadsheet. Unhide a Row or ColumnWhen a row or column is hidden, a button with two arrows will appear on the border between the adjacent row or column headers.
The data reappears once again. You can also select multiple row or column headers that contain hidden data, then right-click and select Unhide rows or Unhide columns.
FREE Quick ReferenceClick to Download Free to distribute with our compliments; we hope you will consider our paid training. How do you hide multiple rows?Hide or show rows or columns. Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent.. Right-click the selected columns, and then select Hide.. What is the shortcut to hide rows in Google Sheets?Note: Some shortcuts might not work for all languages or keyboards. To see a list of keyboard shortcuts in Google Sheets, press Ctrl + / (Windows, Chrome OS) or ⌘ + / (Mac).
...
PC shortcuts.. How do I hide all rows except selected in Google Sheets?1. To hide all unused rows in Google Sheets, select the row header in the first empty row and press CTRL + SHIFT + Right Arrow to select all the rows between the selected one and the last one. 2. Then, right-click anywhere on the selected area and from the menu choose Hide rows (in this example Hide rows 9 – 1000).
How do I hide a range in Google Sheets?Hide sheets from view. Open a spreadsheet in the Google Sheets app.. Tap the sheet you want to hide.. On the sheet tab, tap the Down arrow. .. Tap Hide. This option won't show if your spreadsheet doesn't contain two or more sheets.. Your sheet will be hidden from view.. |