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.

40 comments
-
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.
-
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.
-
Abner commented
it's been so many years since MS offered team collaboration on Office products. This shouldn't take this long to resolve. ONLY changes from any user should be synced so all users see, do NOT sync how 1 user views the document - be it filter, hidden column, etc. Come on MS! Google Docs offers such features years ago. Catch up.
-
Anonymous commented
totally agree on this
-
Anonymous commented
a very frustrating omission from co authoring
-
Anonymous commented
This is becoming a huge issue. Having custom views that don't reset to default once a column is hidden or expanded is critical. Otherwise we're looking at having to maintain multiple spreadsheets with the same information or having to manually adjust rows/columns for each view each and every time. This really needs to be fixed. We are using this in Teams.
-
Anonymous commented
why would the current sheet view feature be limited to sorting and filtering? I dont understand why it would not include columns/row hiding as well.
-
Anonymous commented
Agree with the need for support in "Sheet Views" for hide/group/widths!
-
Bertrand Martin-Garin commented
Hi.
at the bottom of the sheet, there is a first horizontal scrollbar which allows to navigate right to left within the sheet, there is also a second scrollbar which controls the navigation between the tabs of the document. This scrollbar hides all the tabs and it is very difficult to choose one of them.
I wish to hide the scrollbar which controls the tab navigation