...
- 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 Columns | Keeps the first column or the selected column visible while scrolling through the remaining data columns. | |
| Unfreeze Panes | Unlocks all columns, enabling you to scroll through the data. | |
| Fit to | Enables you to resize the column width to fit the size of the headers or the data. | |
| Grouping | Group by | Groups the grid by a column. |
| Ungroup | Ungroups all columns. | |
| Show Group by Pane | Enables you to view groups by pane. | |
| Expand All | Expands all rows in the grid. | |
| Collapse All | Collapses all rows in the grid. | |
| Sort and Filter | Ascending | Sorts data in ascending order. |
| Descending | Sorts data in descending order. | |
| Custom | Enables 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. |
| Find | Find | Enables 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. |