Skip to main content
Version: 3.6

Sort and view

Sort

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.

A screenshot of the Sort window.

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 find Sort in 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 the Sort menu). 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.

Temporarily sorted rows.

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 Reorder rows permanently, the row numbers will change and the Sort menu in the project grid header will disappear. This will apply all current sorting methods.

View

You can control what data you view in the grid. On each column, you will see a View menu 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 View option that appears in the All column’s dropdown menu, you can collapse all columns, and expand all the columns that you previously collapsed.

Show/hide “null”

You can find, under AllView, the option to show and hide “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.

A screenshot of what a null value looks like.

You can go directly to any page by changing the page number on the right-hand side. Using the up and down arrow keys in this input lets you go to the next and previous pages. You can also change the number of rows or records per page on the left-hand side of this view header bar.

A screenshot of the Page Navigation Feature.