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 to display only the most relevant information.

Although this functionality isn't available for rows, you can hide rows by filtering to show only those that contain the information you want to display. 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 columns in Smartsheet, they can export the sheet to Excel or send it as an Excel attachment and unhide the columns in 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 neighboring column headers indicates a 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).