How to hide columns or rows in Google Sheets

Learn to hide columns or rows to reduce data entry errors, focus more easily, compare data more easily, or insert more columns or rows to increase the size of your Google sheet.

  hero-hidecolumn.jpg

What's Hot at TechRepublic

When you create a new Google sheet, the sheet usually starts with 26 columns (labeled AZ) and 1,000 rows (numbered 1 to 1,000). That is 26,000 cells. You don't have to show all these columns and rows all the time; You can hide columns or rows as required.

It may 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 the software, with a row for each function and a column for each software system. With this design, you can compare systems, since the content of each cell describes how each system handles the indicated function. You can hide rows of features that each system offers similarly or hide columns to compare fewer systems.

Here's how to hide, show and insert more columns or rows in Google Sheets in a desktop browser and in Google Sheets on Android and iOS.

SEE: 10 free alternatives to Microsoft Word and Excel (download TechRepublic)

How to hide columns or rows in Chrome

Inside Google Sheets in a browser desktop, you have at least four ways to hide columns or rows.

How to hide a single column or row

  1. Right-click on a column letter or row number.
  2. In the menu that appears, choose Hide column ( Figure A ).

Figure A

  hide-column-chrome.jpg "data-original =" https://tr1.cbsistatic.com/hub/i/r/2019/ 07/25 / 2fc2f60d-2c18-49ef-8fde -1a7fb7f7d0f8 / resize / 770x / 41b3f49ed83b170cc9eacb0b039811c4 / hide-column-chrome.jpg

on the web, select in it or row, then right click (or tap) to access the Hide column option.

How to hide more than one column or row

You can also select Multiple columns or rows. To select more than one column or row:

  1. Click or tap a cell to select it.
  2. Select a specific range or columns. Press Shift while clicking or touching another column or row. For example, you can do this to select columns B through E. Or, to select a set of non-contiguous columns or rows, press Ctrl while clicking or touching on each column or row. For example, you can do this to select columns B, D, and F.
  3. Right-click to display the menu that contains the option Hide columns or Hide rows.
  4. Select Hide columns or Hide rows ( Figure B ).

Figure B

  noncontiguous-hide-rows-chrome.jpg "data-original =" https://tr3.cbsistatic.com/hub/i/ r / 2019/07/25 / dcd49151-1a08-4b10 -afcb-5646d2e7c8f4 / resize / 770x / 06114623aaf585f79fbc03915e1bbac3 / noncontiguous-hide-rows-chrome.jpg

How to hide rows or columns using a keyboard shortcut

1. Click or tap a column or row to select it.
2. Press Ctrl + Alt + 0 (zero) to hide a column, or press Ctrl + Alt + 9 to hide a row .

How to hide rows or columns using the Help menu

1. Select one or more rows or columns.
2. From the menu system, choose Help. Or you can press Alt + / to open the help menu.
3. In the search box that appears, type "Hide" and press Enter ( Figure C ).

Figure C

  hide-w-helpmenu.jpg "data-original =" https: //tr1.cbsistatic.com/hub/i/r/2019/07/25/ac239020-2c23- 4c32-a498-7d74d8c92d5b / resize / 770x / 35c77d3334236407825b8d0d4db65f27 / hide-w-helpmenu.jpg

Alternatively, you can select a column or row, then use the Hide menu, type "Hide "in the search box, then press Enter.