You can temporarily sort your rows by one column. You can sort based on data type:
- text alphabetically or reverse
- numbers by largest or smallest
- dates by earliest or latest
- boolean values by false first or true first.
You can also choose where to place errors and blank cells in the sorting. Text can be case-sensitive or not: if so, cells that start with lowercase characters will appear ahead of those that start with uppercase characters.
After you apply a sorting method, you can make it permanent, remove it, reverse it, or apply a subsequent sorting. When it is applied, you’ll findin the project grid header to the right of the rows-display setting, which will show all current sorting settings.
If you have multiple sorting methods applied, they will work in the order you applied them (represented in order in themenu). For example, you can sort an “authors” column alphabetically, and then sort their books by publication date, for those authors that have more than one book. If you apply those in a different order - sort all the publication dates in the dataset first, and then alphabetically by author - your dataset will look different.
When the sorting method you've applied is temporary, you will see that the rows retain their original numbering. When you make that sorting method permanent, by selecting, the row numbers will change and the menu in the project grid header will disappear. This will apply all current sorting methods.
You can control what data you view in the grid. On each column, you will see amenu option. From there, you can “collapse” (hide) that specific column, all other columns, all columns to the left, and all columns to the right. Using the option that appears in the column’s dropdown menu, you can collapse all columns, and expand all the columns that you previously collapsed.
You can find, under “null” values. A small grey “null” will appear in each applicable cell. Remember that a null cell is not the same thing as an empty cell.→ , the option to show and hide