Filtering without bothering your colleagues

You work with three people in the same invoice list in your WebOké Nextcloud. You filter by "Open", and suddenly your colleague also sees only the open invoices. Or the other way round: someone sorts, and you lose your place. The solution is called Sheet View.

Creating your own view

1. Go to the View tab.
2. Under Sheet View (1), click New. The column and row headers turn a colour, and Euro-Office tells you that you're in sheet view.
3. Now set your filters and sorting. Only you (and anyone who selects the same view) will see these; your colleagues just carry on working in the normal sheet.
4. Done? Click Close to go back to the normal sheet.

Saving and reusing views

Go to View manager to see all your sheet views. Give them a clear name using Rename, for example "Open invoices" or "Utrecht only". Use Go to view to select one again later.

Pitfalls

• A sheet view only saves filters and sorting. If you type an amount in a sheet view, it does change for everyone.
• Sheet views are an Euro-Office feature. If someone opens the file in Excel, they'll see the normal sheet.
• Working with lots of people at once in a large file? Also read Speed up a slow spreadsheet.