Unhide SELECT Columns
Why is it that after you hide several columns, you only have the option to unhide ALL? Or am I being silly and missing something?
Comments
-
Hi,
Unfortunately, it's not possible at the moment to select anything else, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Actually, this is possible. If you right-click to hide a column you can double click on the small space that indicates the hidden column. See my screenshot for an example.
-
This enables you to open individual hidden columns.
-
Mike,
Yes, but it's quite cumbersome and its like a guessing game what column will show
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
True True. But hidden columns in any spreadsheet program operates with the same vagueness. Excel just offers the word "Unhide" when you right-click in that area. Also, in Google Sheets, you can't unhide one column you can only unhide all. The original poster requested the ability to unhide only individual columns and though it is cumbersome, it's available. Just saying.
-
Never thought about how other solutions do it.
Let's hope that Smartsheet implements saved views (Filtered Views), Column Groups or similar.
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
If you click on the column to one side of the hidden set, then SHIFT + Click on the column on the other side (selecting everything in between including the hidden columns) then expand the column widths (even just a wee bit will work) all of the hidden columns that were within the selected range will appear.
You can also use something similar to Hide a set of columns. Select the first column, SHIFT + Click the last column, then click the edge of the column as if you are going to reduce the width. If you move to the left of the left side of whatever column you are using to adjust the column width, the heavy grey bar that shows where the column width will be will jump over to the far left of the column. Once you release, it will hide the selected column(s).
-
Great trick!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks. Hiding and unhiding like this were both completely accidental discoveries. Haha!
-
As are most of the discoveries we make in Smartsheet. #WheresTheDocumentation???
-
Is there a filter view option (that filters columns) not just rows; that would allow me to easily hide/unhide groups of selected columns with a single click?
-
It would be a cool feature to allow columns to expand and contract similar to rows that have parents. This way you wouldn't have to unhide all columns (in my case I have many hidden columns as workarounds) or try to manually unhide individual columns when trying to work at a fast pace.
-
Great tip! It needs to be advertised more explicitly!
-
Glad I could help! :D @Mark A Shampine
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives