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!


1 Answer 1


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.

  • Filter views doesnt seem to work - I collapse and expand groups when in a filter view and other see the groups closing?! Jan 25, 2023 at 16:15
  • 1
    Clarified 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. Jan 25, 2023 at 17:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.