Include/exclude and show/hide device data columns

Google Sheets currently has a maximum capacity of 5 million cells and Gopher for Chrome Premium can include as many as 44 data columns in the Devices tab. This means you are theoretically limited to loading no more than around 45,000 devices if all columns are included.  Large Google spreadsheets can also be quite sluggish, depending on your local resources. 

The Set Visible Columns tab in Gopher for Chrome allows you to limit which column groups to include/exclude as well as to limit individual columns. This means you have the power to work around some of these Sheets size performance limitations. 

Note: Including/excluding column groups is only available for Optional Columns. You can hide individual columns for a column grouping in the Required Columns section. 

Including/excluding column groups

  1. In the sidebar, click Set Visible Columns.
  2. For Optional Columns, toggle the column group to include or exclude.
  3. Click Apply.

Showing/hiding individual columns

Showing and hiding individual columns can also be helpful as you focus on a specific search or bulk update task. Hidden columns are simply collapsed, not removed from the sheet, so they can be restored at any time.

  1. In the sidebar, click Set Visible Columns.
  2. Click Expand at the left of a Required or Optional column group.
  3. Click on the visibility icon for a column to exclude it, click again to include it.
  4. Click Apply.

Note: Freezing columns and rows can also be accomplished by clicking and dragging the gray frozen column separator in the native Sheets UI.

Articles in this section