Sorting, filters and slices
Posted: Tue Jan 21, 2025 6:52 am
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 japan telegram 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.
Sorting
The simplest type of sorting is ordinal. Cells with japan telegram 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.