隐藏列列表

Nik Fuentes

我想有一个collapsable/expandable list of all hidden columns on a sheet with the option to unhide them from the list. This way, if I have multiple hidden columns and I just want one or two of them, I don't have to unhide everything to get to them. This would also allow you to look for columns that might be hidden without unhiding everything and needing to re-hide it again.

I know that you can unhide one column at a time, but if I have a block of 8 hidden columns and I want the 4th one, I either unhide all 8, or manually unhide 4 one at a time. Neither is ideal.

Sameer K

Current functionality to hide and unhide columns is not very efficient. Suggesting a better interface to show/hide columns just like Smartsheet has in Reports to select columns to be displayed. See below,

svenu

Totally agree! When the sheets become longer with a lot of information, it does get difficult to unhide all the columns and then go hide them one by one.

Adrian Mandile CHESS

If columns could have a'Hidden'attribute in their column properties like in Forms, then we could have a'Hide Columns'option in the right-click column menu, instead of only'Show All Hidden Column'and then no efficient way of re-hiding them all.

Also, some way to distinguish these'Hidden'columns when they are made visible, by allowing some form of user-selected (conditional?) formatting within the sheet would also be informative/useful.

Adrian Mandile CHESS

Frank Falco

I agree with Adrian on this. We need not to show hidden columns in forms.

I also would like to see all of what is being proposed in this idea implemented.

Scott Peters

Related - It would be nice to hide/reveal hidden columns in the field picklist when creating a sheet filter

Pat Canning

The system allows users to hide columns individually or in blocks - good. Unhiding those columns - bad. There are currently only two alternatives to unhiding columns - unhide all, which is ridiculous overkill that requires users to then unhide all the unwanted columns, or unhiding them one at a time by dragging the vertical column separator. This second option is inefficient in that it's one-at-a-time, and undesirable in that unhiding is a manual drag that does not preserve the previous column width. There should be an option to select a block of columns and unhide all columns in that range at the previously saved column widths.

Like functionality should also exist for hiding rows.

Samuel Mueller

For example, in the edit box when you edit a row, add a column with a checkbox where you can hide and unhide any column in the sheet, something like this: