Unhide specific columns on a sheet

Rachel Wrobel

Instead of unhiding all columns to find one or two that are needed, it'd be great to be able to unhide specific ones, like Excel does with Tabs.

Vanessa Scott

The ability to unhide a single or range of hidden columns without having to unhide all of them.

红杉。

It seems this is a perennial request. I've found comments on this issue back to 2015, at it is no better in 2023. Very clunky interface. In Excel, if I know Column H is hidden I can use GoTo to go to H1 and then Alt+Col+Unhide. There is no equivalent in Smartsheet. I'm currently working on a project where, to unhide a column just to the right of a known column, I have to drag about 8 other columns unhidden, finally revealing the column I want. Then I have to hide those 8 columns again.

Come on Smartsheet, y'all can do better.

MariaCurtis

Please yes!

Sarah123

This would be a GREAT feature. If you have the Control Center option on your plan you could potential do this by going to Global Update and selecting to modify an existing column and in the Advanced section uncheck the hidden box. It's not a great workaround - but if you wanted to unhide the same column (and you could do the same to rehide one) in multiple projects this is an option. But I agree, being able to unhide one column within a sheet would be ideal.

Josh W

Here is a trick I just figured out;

Let's say you have multiple groups of columns hidden, and you want to see just one groups. Rather than unhiding the entire sheet, or dragging the width of the hidden columns one by one, you can do this:

Highlight the two columns that straddle the hidden group you want to see. Slightly adjust the width of the column on the right. This will cause the hidden columns in between the two selected ones to unhide all at once, without disturbing the rest of the sheet.

Not a bad workaround, as long as you know where the column is that you want to view and it's not buried in a huge group of hidden cells :-)

Ian Cooper

The unhide feature in Smartsheet needs some work. With the amount of help cells necessary for time formulas, I end up with several hidden columns. Any time maintenance or trouble shooting is needed, instead of just unhiding the column that is needed, everything gets shown. This makes it incredibly frustrating.

MichaelTCA

Hello,

Having to unhide all columns at once can be overwhelming for new users. From a developer stand point, it's horrible. I usually have to unhide all columns to develop automations and procedures through multiple sheets and reports. Just to properly set up a lookup function can be difficult for new employees who haven't used our procedures much.

It's not a big problem if 1 person is running the show, but as soon as multiple brains get put together and want to start developing procedures within their own departments, data can be easily forgotten and duplicated.

Some sort of task manager to show a list of the columns with the ability to possibly check/uncheck the individual columns that you want to be shown would be great! It can be set up on the right side bar and operate the same as the rest, within that bar, having the window that slides out after making a selection.

Like I mentioned above, as soon as there's more than 1 person working within the same sheet, confusion can easily be caused by a mis-click and the feeling of "starting over" the task (hiding columns) comes on.

Nik Fuentes

I won't pretend to know how difficult it would be to implement this feature, but I can assure you that it isdesperatelyneeded. The frustration of navigating around hidden columns by unhiding all is immense [especially since the unhide 1 option undoes column width settings].

Having a tool on the taskbar with the list of columns, their type [text/num, date, formula, locked, etc], their status [hidden/unhidden], and the option to change their status would alleviate all of my problems.

I work with big sheets with a lot of helper columns with a bunch of other admins. Unhiding all every time is intensely frustrating. Please give this higher priority, it has ben a problem for years now.

Adrian Mandile CHESS

This idea is related to the following post:

I would love to have a 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.<\/p>

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.<\/p>","bodyRaw":"[{\"insert\":\"I would love to have a 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.\\nI 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.\\n\"}]","format":"rich","dateInserted":"2022-09-16T18:09:16+00:00","insertUser":{"userID":138105,"name":"Nik Fuentes","url":"https:\/\/community.smartsheet.com\/profile\/Nik%20Fuentes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2L6JP17FBEN7\/n3IWD70UPYLDQ.jpg","dateLastActive":"2023-08-24T19:14:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/95450\/hidden-columns-list","embedType":"quote","name":"Hidden Columns List"}"> https://community.smartsheet.com/discussion/95450/hidden-columns-list

Let's try to combine our votes, so we get some Smartsheet action!

Mike Jungers

I've seen two types of solutions that work well for hiding/unhiding columns in other software I use:

• 使用下拉列表设置预定义的“观点”f column names with checkboxes for visibility within that each view. UDA ConstructionSuite uses this method but the pre-defined views cannot be renamed. The ability to name views would be superb.
• A simple "Hide" drop-down menu with nice, large radio buttons like Asana. Each has to be toggled individually but the large buttons are easy to select quickly.

If SS would implement either approach I would be be happy. On a positive note, SS will print to PDF exactly what I'm seeing on screen, which makes it easy to generate one-off reports using column visibility and widths. This works far faster and more predictably than other platforms I use.