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.
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.
totally agree on this
a very frustrating omission from co authoring
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.
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.
Agree with the need for support in "Sheet Views" for hide/group/widths!
Bertrand Martin-Garin commented
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
Joseph Wal commented
Adding the views created by Split and Freeze Panes to the list would be helpful as well.
Changing the width/height of the column/row also seems to affect other's sheet view while working on the file at the same time.
So things that need improvement that are currently affecting others are:
1. Hide/Unhide the rows/columns
2. Group/Ungroup the rows/columns
3. Change the widths/heights of the rows/columns
If anyone has more issues, you can add to this list.
Hope to have these fixed as soon as possible.
Lindsay Short commented
This would make sharing larger data sets where different users have different needs much more practical - at the moment it makes this type of sharing via sharepoint useless for our data sets
this is making Excel on the Web unworkable for us - team are starting to look at alternatives
Also sheet view NEEDS to be added to the desktop version, but ONLY with this feature.
Microsoft, you can't push a product as an enterprise solution and then not allow enterprise collaboration without a bunch of special rules and recommendations how suddenly now that you're Office 365 you have to change your ENTIRE workflow. How do you expect 100 people or more to work on a spreadsheet at the same time and not ***** each other over without private views?
One additional request:
Grouping/Un-grouping the columns/rows also affecting others. So need these remain personal when using Personal Sheet View.
agreed, it is currently inconsistent with excel desktop..
The same problem, if someone disable filters, it disable it for all views. Can that be added to the mentioned idea?
Why doesn't Teams have the same functionality as SharePoint where multiple people can work on a document at the same time?
Noe Lavigne commented
Seriously need this function to applied when you Hide COLUMNS !!
The view tabs in Excel online add no value compared to a simple filter except that it is a saved filter setting...
Need the same can of view capability compared to the desktop version
Microsoft needs to learn from Airtable. The views there are handled in such a orderly fashion, it's incredible. Not here to advertise the software, but rather point someone in the Microsoft development team to look at a tool that has gone beyond just a basic spreadsheet tool.
[Deleted User] commented
This would definitely be handy. We have a task progress board and with many columns it can be difficult to scroll through - some users only need to be aware of certain stages of progress so hiding columns for them would save a lot of time scrolling.