Hide or Unhide Columns

The sheet owner and licensed collaborators withAdminaccess to the sheet can hide a column to remove it from view while still keeping its content available in the sheet.

Though this functionality isn't available for rows, you canapply a filterto the sheet to hide rows based on criteria they contain. The filter will impact only your view of the sheet and other collaborators can apply their own filters as needed.

Hiding is useful when your goal is to format the sheet such that it displays only the most relevant information. Hiding is not a security feature. While collaborators withEditorandVieweraccess won't be able to unhide the columns within Smartsheet, they canexport the sheetto Excel orsend it as an Excel attachmentand un-hide the columns from that program.

Hide a Column

To hide a single column, hover over the column name and then click theMoreicon. SelectHide Columnfrom the menu.

隐藏多个列,按住the [Ctrl] (Windows) / [Cmd] (Mac) key as you single-click on the header of each column you want to hide. Then click theMoreicon and selectHide Column.

Unhide Columns

The sheet owner and Admins can unhide all columns by clicking theMoreicon in any header and selectingUnhide All Columns. Unhide a single column by click-and-dragging the double-bar (which represents a hidden column) in the column header.