...
- In 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 the drop down menu, you can select tone of the following options:
Click... To...Option Description Columns Select the column(s) to display in the data grid by checking next to its name. Select All Select Selects all columns Clear All Filters Clear Clears all filters applied Unfreeze Unfreeze Unfreezes panes Expand All Expand Expands all group entries Collapse All Collapse Collapses all group entries by column values Fit to Header Adjust Adjusts the column to width of the header Fit to Data Adjust Adjusts the column to width of the data Restore Defaults Restore Restores default settings Refresh Refresh Refreshes settings To change the location of a column, drag and drop the column header from its original location to a 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.
...
- In the workspace in which you are working, click the Home tab.
- Click to select a row in the workspace and click View Row.
You see the View Row dialog. - In the View Row dialog the row details are displayed in vertical format. You can navigate backward and forward through all the rows in the workspace by using the Previous Grid Row and Next Grid Row arrows.
- The following options are available in the View Row dialog.
- Click Close.
...
- .
...
- Excel (Office xm)
- EXcel (csv)
- Text (txt)
...
Copy Workspace Data via the Clipboard
...