Maintain hidden rows/columns in "sheet view" so other users are not affected by the change
Sheets view offers a private view of the Excel sheet when sorted or filtered, another common change is hiding rows/columns but that currently affects all users when sharing document.
Allow for row/column views to remain private in Sheet View so others are not affects.
Troy Finney
shared this idea
54 comments
-
ChrisFromNorth
commented
Update your Excel365.
Excel asks if you want to see only your Filter or if you want also see the filter of others. -
CrisR
commented
@JB Not that I have seen. We are still very interested in this functionality at my organization.
-
JB
commented
MS - is there any update on this update?
-
Stefanie
commented
Just chiming in to say here we are over a year later and this still seems to be unaddressed. This seems like a pretty reasonable expectation for a user view to be able to hide unneeded (or sensitive) columns (or rows). Any thoughts on why we can't have this functionality?
-
Electra Garrigo
commented
Please make it possible for columns to be hidden under filter views!
-
David Lewis
commented
What is the chance of MS actually doing this...
Anything that changes the *value* of a cell should be reflected globally. Anything pertaining to how the sheet is *viewed* should be private/local to the view - or at least, give a block of checkboxes so the user can select which view attributes remain private and which are "inherited" from the default view.
-
CrisR
commented
This is a serious issue for my organization as well. Will have to consider moving to a more robust relational database if this can't be solved.
-
Anonymous
commented
As well as hiding columns, users should be able to change the sizes of columns without others being affected.
-
Anonymous
commented
without this its a total disruption creating impaired productivity
-
Boris
commented
Definitely useful and needed :)
-
Carl Von Schantz
commented
Yes. Needed.
-
Nichole
commented
Please, please, please make this update ASAP! It is very frustrating that it isn't a built-in feature of the "sheet view" already. This issue is a total disruption to our team making updates in an important tracker regularly.
-
Anonymous
commented
OMG yes please its pretty useless without this functionally
-
Adam
commented
I couldn't agree with this suggestion more! Please add this to sheet view!
-
Marissa
commented
Why would they create a "sheet view" function that works for everything except hiding/unhiding columns! HELP
-
Roberto Enríquez
commented
Please add support for different user views in expanding or collapsing groups (columns and rows) to the sheet view option. Is crazy when collaborating a bunch of people fighting over the collapsing/expanding columns as they preffer
-
Daniele Repici
commented
Please add support for hide/show rows/columns and expand/collapse groups to the things that pertain to the sheet view.
It is annoying that I see my spreadsheet doing crazy things while I am viewing it, just because some other user is hiding columns for their own sake.
-
Anonymous
commented
We were looking at Sheet View as a potential solution to our shared user problem. But if it doesn't include collapsed column groups and hidden columns in the personalized view, then it's basically useless.
To echo some other comments. Anything that changes the *value* of a cell should be reflected globally. Anything pertaining to how the sheet is *viewed* should be private/local to the view - or at least, give a block of checkboxes so the user can select which view attributes remain private and which are "inherited" from the default view.
-
Rob Evans commented
I'm really disappointed with the sheet view functionality, it is great to be able to create your own filter but you need to be able to freeze your own columns too. we have a big spreadsheet shared by several different departments who own several columns of data but if you group the data fields together to make it easy to navigate, the view changes when people expand and collapse the groups in a different sheet view :(
-
Mike B
commented
Huge upvote here. I'm using the sheet view functionality for the first time today, and the fact that hiding cells can't be personalized is making the ability to do real-time editing in shared documents almost pointless in its entirety.
