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
7 comments
-
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.