...
- On the top of the workspace in which you working, click on the Grid tab.
- Click the column header. The column data is sorted in descending order by default. To sort the column data in ascending order, click the column header. To revert the view of the column values to descending order, click the column header again.
Click the three red lines in the top row of the first column to display a drop down menu.
From this menu you can select the following options:
| Click.. | To.. |
|---|---|
| Columns | Select the column(s) to display in the data grid by checking next to its name |
| Select All | Select all Columns |
| Clear All filters | Clear all filters applied |
| Unfreeze | Unfreeze panes |
| Expand All | Expand all group entries |
| Collapse All | Collapse all group entries by column values |
| Fit to Header | Adjust the column to width of the header |
| Fit to Data | Adjust the column to width of the data |
| Restore defaults | Restore default settings |
| Refresh | Refresh settings |
...
To change the location of a column, drag and drop the column header from its original location to the new location.
- To change the column characteristics, click the arrow in the top right corner of the column header. You can sort, add, remove, freeze, find, and filter the column, as well as set date filters.
- To clear all custom settings, click Restore Defaults.
Rearrange Workspace Columns
To rearrange workspace columns:
- On the top of the workspace in which you are working, click the Grid tab.
- Click Columns.
- Click to select a column name to display it. If the column name has a check mark next to it, it will be displayed. If there is no check mark, it will not be displayed.
- To rearrange the column order, click More on the Columns drop down.
- Click Add to add a column, or click Remove to remove a column.
- In the Selected columns pane, click the column name that you want to rearrange. Move the column up or down by clicking the Up or Down arrows.
- Click OK to save the column order changes or click Cancel to revert to the original column order.
- To clear all custom settings, click Restore Defaults.
...