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
    Oct 24 at 5:01

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 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 at 17:46

Your Answer

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

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