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
13 comments
-
Martin
commented
The same problem, if someone disable filters, it disable it for all views. Can that be added to the mentioned idea?
-
Anonymous
commented
afas
-
Lauren
commented
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
+1 here
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
-
Anonymous
commented
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.
-
Anonymous
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.
-
Phil Renda
commented
All- per Microsoft, we will need more votes for this to be considered. Please share this link with anyone in your organization or analytical communities that may have the same problem to vote so we can get this on the road-map. Thank you
-
Brian
commented
I need something like. I work out in the field and use a shared spreadsheet with the salesperson. This way I can mark what has been completed and make changes as they occur and the salesperson can add more items to it. I would like to share this same spreadsheet to the field supervisor as well, but can't because the spreadsheet also has a column for pricing. That info can not be shown to the supervisor. If I can just hide that to a specific user, then we can all communicate just a little more better.
-
Mike Ruby
commented
The ability to hide columns for the current user only, is essential for collaboration. Additionally, it would be helpful to have admin control of visibility and access to columns/fields.
-
Ammar Al-Rifai
commented
Definitely would assist folks not missing any data due to being filtered by a different user
-
Anonymous
commented
Yes, "Sheet View" also needs to provide as way of not affecting other users when columns are hidden. Can't believe Filtering is hidden but hiding of columns still affects all users. Is this still something that is pending? I sure hope so.
-
Anonymous
commented
When this is implemented, make sure it has ability to set views on Rows AND Columns!!!!!!!!
-
Phil Renda
commented
This is essential for my workplace. We have a large, collaborative/ shared file that has 180 columns and is updated by multiple teams. People need to see columns that are only pertinent to their subject area. The work around (so hiding columns doesn't affect all users) is very difficult to develop and maintain (Power Apps + Power BI or Sharepoint List + Power Automate). I hope this is simple enhancement as it would save us a tremendous amount of work.