Рет қаралды 20,586
Collaborating and co-authoring in Excel can be frustrating. If one person changes the worksheet view - applying filters and sorting - it applies for all users. This can be really disruptive.
Fortunately, Excel offers a feature called "Sheet View" which lets you create a temporary view just for you. In this view, your custom changes won't impact others and their custom views won't impact yours.
This is a great feature to use whenever you're working in a shared Excel file.