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
47 comments
-
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.
-
Andy Jorgensen
commented
Big upvote for this one. My engineering team is stepping all over each other's toes trying to collaborate on a big job.
-
Quentin
commented
Similar requests also for Excel for the web: https://excel.uservoice.com/forums/274580-excel-for-the-web/suggestions/39398026-maintain-hidden-rows-columns-in-sheet-view-so-ot
-
Steve C
commented
Need the private views to include column changes per user. Pointless without it.
-
Remy
commented
absolutely necessary for us in desktop version
-
Rebecca Nalevanko
commented
I wish I could vote more than once. If I can see everyone else's filters, it significantly inhibits collaboration since I can't work on the file when someone else filters or hides columns based on their interests. I would rather go back to our prior semi-shared files since at least then I could look at a file that someone else had checked out without being forced to look at what they are looking at.
-
Bran
commented
Seconding this. My team needs to have the ability to filter their data (alerts) by their username. When doing this, it's not showing all the rows of their data. Filtering also shouldn't affect anyone elses view while the user is updating that row/column. Microsoft, PLEASE IMPLEMENT THIS ASAP.
-
Anonymous
commented
I would like the ability to create specific sheet views by hideing specific columns.
Unfortunately hideing columns is not part af the sheet view.
Would you please look into the option to allow users to create personal views by hideing columns not only filtering rows?