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) How to hide columns or rows in ChromeWithin 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
|