Sometimes when working with a table or a view of a table, you'll have columns that aren't relevant to your audience. These might be columns that are used for interim calculations, that run automations on the back end, or that you use to filter records but don't want to show your audience. In these cases, you may want to consider hiding columns.
By hiding or un-hiding columns, you can control what your doc's end users will see for a given view. Hiding columns is view-specific and doesn't change what hidden formulas do.
The primary way to manage column order and visibility is via the column panel. From the column panel you can also change column types, add columns, remove columns, rename columns and reorder columns.
To manage columns in the column panel:
- Click on the table container so that the Filter, Sort, Columns, and Options links appear.
- Click the "Columns" option so that the column panel opens on the right.
- Visible columns will show up with a blue eye icon, and hidden columns will be gray. Click on any visible column to hide it, and any hidden column to un-hide it.
- You can also re-order columns from the column panel by dragging column names up and down.
- Click on a column icon to change the column type or delete the column
- Click on a column name to rename it
- Click 'Add column' to create new columns
Here's an example of how these options look:
To hide an individual visible column, you can also select and right-click on an individual column's header to pull up the column menu, then select "Hide":