Interpret data in your spreadsheet
Create a named filter
To create a named filter: Select the desired cells and tap Filter under the Data menu. Enable the Filter Toggle button. The filter gets applied to the column header of the selected range of cells. Tap the filter icon on the desired column, and apply ...
Use Zia for better data analysis
Zia is an AI assistant that when given a particular set of values will recommend charts and pivot tables to make data analysis easier. To get recommendations from Zia: Select the desired range of cells. Tap Insights with Zia under the Data menu. The ...
View named filter
To view a named filter: Go to Filter under the Data menu and tap Named Filter. Tap ... besides the name of the filter to edit or delete the existing filter.
Filter a set of data
To filter any set of data: Select the desired range of cells. Tap Filter under the Data menu. Turn on the Filter toggle button. Tap the drop-down inside the cell and provide values for the required criteria.
Custom sort data
To sort the desired data based on other columns in your data: Select the range of cells you wish to custom sort. Tap Custom Sort under the Data menu to customize the type of sorting. Select the type of sort from the drop-down and tap Apply.
Sort data in a cell
To sort data in cells: Select the range of cells you wish to sort. Under the Data menu, tap either on or based on whether you want to sort data in ascending or descending order. The default sorting will be based on the first column of the selected ...