Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Quickly select the data set shown in the grid with filters for item type, groups, or custom filters.
  • Add, remove, and reorder grid columns for each field in the current list of data.
  • Find a value that exists as part of a set of data.
  • Sort the data set by a single column or create a custom sort with multiple columns.

Grid Tab

Grid tab of ribbon

Group

Control

Description

Columns

Columns

Hides and enables columns in the grid.


Freeze ColumnsKeeps the first column or the selected column visible while scrolling through the remaining data columns.

Unfreeze PanesUnlocks all columns, enabling you to scroll through the data.

Fit toEnables you to resize the column width to fit the size of the headers or the data.
GroupingGroup byGroups the grid by a column.

UngroupUngroups all columns.

Show Group by PaneEnables you to view groups by pane.

Expand AllExpands all rows in the grid.

Collapse AllCollapses all rows in the grid.
Sort and FilterAscendingSorts data in ascending order.

DescendingSorts data in descending order.

CustomEnables you to create multiple custom sorts for the grid.

 

Custom Filter

Enables you to create custom filters for the grid.

 

Clear Filters

Enables you to create custom filters for the grid.

View

Show

Displays row numbers and vertical gridlines.

 

Compare

Enables you compare two or more rows by displaying your selections in a dialog box with options for highlighting differences in the data. 

FindFindEnables you to find data in the workspace.

Refresh

Refresh

Refreshes the results in the workspace.

Settings

Restore Defaults

Clears custom settings that were applied to the grid.