Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

  • Owner
  • Admin

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 such that it displays only the most relevant information.

 

Though this functionality isn't available for rows, you can hide rows by filtering on rows containing the information you want to show. You can use the filter and share it with other collaborators. For details, see Create a filter to show or hide data.  

 

Hiding columns is not a security feature. While collaborators with Editor and Viewer access won't be able to unhide the columns within Smartsheet, they can export the sheet to Excel or send it as an Excel attachment and un-hide the columns from that program.

 

Hide a Column

  1. Hover over the column name and then click the Column Menu icon  More icon in column header .
  2. Select Hide Column from the menu. 

Column menu expanded after clicking More on the column header
 

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

Brandfolder Image
Hidden column indicator

Hide multiple columns

  1. Hold down the [Ctrl] (Windows) / [Cmd] (Mac) key as you single-click on the header of each column you want to hide.
  2. Select the Column Menu icon  More icon in column header  of one of the columns and select Hide Column.

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

Unhide Columns

To unhide columns, select the Column Menu icon  More icon in column header   in any header and select Unhide All Columns.

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