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:
- Hover your cursor over the table so that the Filter, Sort, Columns, and Options links appear.
- Click the "Columns" option to open the column panel on the right.
- Visible columns will show up with a blue eye icon, and hidden columns with a gray icon. Click on the eye icon to hide and unhide columns.
- 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, or right-click the column name.
- Double-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":