Versions Compared

Key

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

...

  1. In the workspace in which you working, click on the Grid tab.
  2. 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.
  3. Click the three red lines  in the top row of the first column to display a drop down menu.


  4. From this the drop down menu, you can select tone of the following options:

    Click...To...OptionDescription
    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


  5. To change the location of a column, drag and drop the column header from its original location to a new location.

  6. 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.

  7. To clear all custom settings, click Restore Defaults.

...

  1. In the workspace in which you are working, click the Home tab.
  2. Click to select a row in the workspace and click View Row.
    You see the View Row dialog.
  3. 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.
  4. The following options are available in the View Row dialog.
  5. Click Close.

...

  1. .

...

  • Excel (Office xm)
  • EXcel (csv)
  • Text (txt)

...


Copy Workspace Data via the Clipboard

...