Filtering, sorting, and

rearranging data

• Group
  To group the display by a column, select a column header and drag this to the area labeled Drag a column header to the group location to group the results by that column located to the top left of the columns.
• Sort order
  Select the column header to change the sort order. A small triangle points to indicate if the sorting is ascending (A-Z) or descending (Z-A). Hold the Shift key when selecting headers to sort against multiple columns simultaneously.
• Filter
  Select the lookup   to choose a filter type (contains, does not contain, starts with, ends with, equals, does not equal) and enter the value in the field to the right of the lookup.
• Column Order
  Drag the column headers to the left or right to change the column order. The Customer and Location columns each have a main column header that lets you drag all three columns (Notes, Name, ID) at the same time. You can also rearrange the Notes, Name, and ID columns beneath both the Customer and Location headers.
• Scrolling
  A horizontal scrollbar is hidden until you hover with your mouse at the bottom of the grid. When the horizontal scrollbar displays, you can drag the bar to view more columns. A vertical scrollbar is automatically displayed.

Buttons on this window