Sorting filters and slices

[hasibaakterss3309]

In Tables, you can sort and filter data, and slice and dice to view quick summaries. The tools for doing this are in the Data tab.

Sorting
The simplest type of sorting is ordinal. Cells with france telegram number database numbers can be arranged from the smallest value to the largest and vice versa, and cells with text can be arranged in alphabetical order.

Google Sheets: A Complete Guide to Using the Tool

Important! If the table has a header row, then when you select the entire column, it will also participate in sorting and may shift. To avoid this, use the "Sort Range" command, having previously selected the desired cells on the sheet, except for the header row.

Google Sheets: A Complete Guide to Using the Tool

Filters
Using filters, you can hide cells that are temporarily not needed. This is convenient if you need to analyze a large amount of information. For example, you want to view statistics on products from one category, but the sheet contains data on all products. In this case, you need to set a filter with a condition.

There are two tools for working with filters: "Create Filter" and "Filtering Modes". When using the first one, all users who have access to the document will see the data sorting. If you only need the filter and you do not want it to disturb your colleagues, use the tool "Filtering Modes" → "Create New Filter".