Can anyone help? I have a huge sheet with lots of filters and groups. Does anyone know if a way I can great views with certain groups expanded and others collasped that doesnt affect what other users view? in other words I want to expand certain groups but if anyone else is in the sheet they may want them collapsed, if that makes sense!
-
This question has been bumped by Community User thress times.– Rubén - Volunteer Moderator - ♦Commented Oct 24, 2023 at 5:01
Add a comment
|
1 Answer
In Google Sheets, almost all view options are shared in real time between all users, which means that you cannot use grouped or hidden rows or columns without having other simultaneous users experience the same changes.
The only exception is filter views that let you and other users decide which rows to show at a time independently of each other, all without disturbing each other. Filter views also let you sort data in the view, without changing the storage order of rows. Filter views are different from regular filters.
You can save filter views and give them descriptive names. For additional ease of use, you can insert links in the frozen section of the sheet to easily switch between filter views, instead of having to go to Data > Filter views to switch. See the Filter views example spreadsheet for an illustration.
answered Jan 25, 2023 at 16:13
-
Filter views doesnt seem to work - I collapse and expand groups when in a filter view and other see the groups closing?! Commented Jan 25, 2023 at 16:15
-
1Clarified the answer. Changes in row and column groups are visible to all users. Filter views are the only view type that is "private" to you. Commented Jan 25, 2023 at 17:46