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.
on July 31, 2019, 8:56 AM PDT Learn how to hide columns or rows to reduce data entry errors, narrow focus, more easily compare data, or insert more columns or rows to increase the size of your Google Sheet. When you create a new Google
Sheet, the sheet typically starts with 26 columns (labeled A through Z) and 1,000 rows (numbered 1 through 1,000). That’s 26,000 cells. You don’t have to display all of these columns and rows all the time–you can hide columns or rows as needed. It can be especially useful to hide columns or rows as you enter or compare data. For example, technology professionals often use a Google Sheet to help evaluate software, with a row for each feature and a column for each software system. With this
layout, you may compare systems, since the content of each cell describes how each system handles the feature indicated. You might hide rows of features that each system delivers similarly, or hide columns to compare fewer systems. Here’s how to hide, unhide, and insert more columns or rows in Google Sheets in a desktop browser and in Google Sheets on Android and iOS. SEE:
Google Sheets: Tips every user should master (TechRepublic) Within Google Sheets in a desktop browser, you have at least four ways to hide columns or rows. How to hide a single column or row
Figure A In Google Sheets on the web, select a column or row, then right-click (or tap) to access the Hide Column option.How to hide more than one column or rowYou may also select several columns or rows. To select more than one column or row:
Figure B Hold the Ctrl key as you select individual rows or columns, then use the right-click menu to hide the selected rows or columns.How to hide rows or columns using a keyboard shortcut1. Click or tap on a column or row to select it. SEE: 10 free alternatives to Microsoft Word and Excel (TechRepublic download) How to hide rows or columns using the Help menu1. Select one or more rows or columns. Figure C Alternatively, you may select a column or row, then use the Help menu, type “Hide” in the search box, then press Enter.How to hide columns or rows on Android or iOSYou may also hide one or more contiguous columns or rows in Google Sheets on Android or iOS devices.
Figure D (Left) On Android, you access the Hide Column option with the three vertical dot menu, after you select a column or row. (Right) On iOS, you access Hide Column (or rows option, as shown here), with a few taps on a triangle that points to the right, after selecting a column or row, then tapping in the shaded area.How to unhide columns or rowsGoogle Sheets displays small arrows on either side of a hidden column or row–tap or click on those arrows to unhide the cells between the columns or rows indicated (Figure E). Figure E In Google Sheets on any platform, click or tap on the arrows between columns or rows to unhide the section.How to insert columns or rows in Chrome, Android, or iOSInsert columns or rows in ChromeYou may add any number of columns or rows, as long as the total number of cells remains less than the limit of five million cells (as of July 2019). Need more rows? Scroll to the bottom of the sheet. In the lower left the system displays an Add button and number box followed by More Rows At The Bottom. Type in the number of rows you want to add (Figure F). Figure F In Google Sheets in Chrome, scroll to the bottom, then enter the number of additional rows you wish to add.Need more columns? Click or tap on a column, then select the Insert menu and select either Insert Column Left or Insert Column Right. If you select more than one column or row, then right-click– you can insert new blank columns or rows equal to the number of columns or rows you selected (Figure G). Figure G In Google Sheets in Chrome, you may select several columns or rows, then right-click to insert the same number of new columns or rows as you selected.Insert more columns or rows on Android or iOSYou can insert columns or rows on a mobile device as well. The process is similar to how you hide columns or rows on Android or iOS in Sheets. 1. Tap the column or row where you want to insert a column or row–this selects the column
or row. (Figure H) (Left) On iOS, you will find the option to Insert columns or rows in a similar manner as the option to Hide columns. (Right) On Android, tap to select columns or rows, then tap the + (in the upper right), then scroll down to choose Insert OptionsAlso See
Is there a way to hide rows in Google Sheets?To hide a row, right click on the row number on the left of the spreadsheet and choose Hide row. To hide multiple rows in a Google Spreadsheet, click on the first row and drag across the rows you wish to hide, or hold the Shift key and click on the last row you want to hide.
How do I hide cells in Google Sheets without right clicking?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."
What is the shortcut to hide rows in Google Sheets?PC shortcuts. How do I hide rows without right clicking?Hide Rows Using Shortcut Keys
The keyboard key combination for hiding rows is Ctrl+9: Click on a cell in the row you want to hide to make it the active cell. Press and hold down the Ctrl key on the keyboard. Press and release the 9 key without releasing the Ctrl key.
|