Hide or unhide columns

Hide irrelevant columns to declutter the user's view.

Who can use this?

Plans:

  • Pro
  • Business
  • Enterprise

Permissions:

  • Owner
  • Admin

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

You can hide columns to remove them from view while still keeping their content available in the sheet. Hiding columns is especially useful when you want to format a sheet so that it displays only the most relevant information.

Although this functionality isn't available for rows, you can hide rows by filtering for only those that contain the information you want to show. Learn more about how to create a filter to show or hide data.  

Hiding columns isn't a security feature. While collaborators with Editor and Viewer access can't unhide the columns within Smartsheet, they can export the sheet to Excel or send it as an Excel attachment and unhide the columns from that program.

Hide a column

  1. Hover over the column name, then open the column options menu  More kebab menu.  .
  2. Select Hide column from the menu. 
Hide columns in a sheet

A double bar between the neighboring column headers represents the hidden column.

Hide columns in a sheet

Hide multiple columns

  1. Hold down the [Ctrl] (Windows) / [Cmd] (Mac) key as you select the header of each column you want to hide.
  2. Select the column options menu  More kebab menu.  of one of the columns, and select Hide column.

Double bars between neighboring column headers represent each hidden column or sequence of hidden columns.

Unhide columns

  1. In any column header, select the column options menu  More kebab menu. .
  2. Select Unhide all columns.

You can also unhide a column by horizontally dragging its hidden column indicator (double-bar marking its position in the column headers).