When working on huge documents we need to work on different sets of data but from the same sheet on Teams.
Sometimes I need to hide columns or rows, use filters, different sorting to pinpoint the data I need to work on. The issue is, the other person see those applied filters and sorting as well, while the other persons needs something completely different and we simply disturbing each other. In result we can't work on the same document in the same time.
I cannot believe that this is so badly implemented. There must be a way to disable filtering and sorting from sharing so we all could use it without getting in each others way.
I cannot find anything in google so I hope someone here has an answer to it. It has to be something basic and obvious, such obvious that nobody talks about it anywhere and nobody knows anything about it...
Thanks for your help.