You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a need and I wonder whether anyone else has had that need and found the solution.
Here's something that happened today, and happens quite frequently: I opened a sheet with 20+ columns. I needed to look at 3 of its columns side by side so I could compare them. They were not positioned close to each other, so I had to search for them and move them to be closer to each other using Shift-H and Shift-L. This takes about 30 seconds.
I have many CSVs with the same structure that I'm examining as I'm iterating on experiments. I keep having to do this 30 second column shuffle on every open.
I would like to have some automatic way to say "Show only columns foo, bar and baz". Does anyone have a way to do that?
I could write a script for this specific set of columns, but this happens in different kinds of sheets where I want to have different subsets of columns. I considered making a script that lets me define column subsets, and then apply them to the current sheet or edit them. But this would be quite an involved UI for a script. If anyone has a different solution, I'll be happy to hear it.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I have a need and I wonder whether anyone else has had that need and found the solution.
Here's something that happened today, and happens quite frequently: I opened a sheet with 20+ columns. I needed to look at 3 of its columns side by side so I could compare them. They were not positioned close to each other, so I had to search for them and move them to be closer to each other using
Shift-H
andShift-L
. This takes about 30 seconds.I have many CSVs with the same structure that I'm examining as I'm iterating on experiments. I keep having to do this 30 second column shuffle on every open.
I would like to have some automatic way to say "Show only columns foo, bar and baz". Does anyone have a way to do that?
I could write a script for this specific set of columns, but this happens in different kinds of sheets where I want to have different subsets of columns. I considered making a script that lets me define column subsets, and then apply them to the current sheet or edit them. But this would be quite an involved UI for a script. If anyone has a different solution, I'll be happy to hear it.
Beta Was this translation helpful? Give feedback.
All reactions