Manage Workspace Columns and Rows

In Eagle workspaces, you can manage how data columns are displayed, arranged and grouped. You can freeze or unfreeze panes or specific columns, or select additional columns to be displayed. You can also sort column data displayed in the workspace, use custom filters to customize which data is displayed based on specific criteria, display row numbers and vertical lines in the workspace, and view rows in the workspace vertically for easy readability.

Display Workspace Columns

To customize how workspace columns are displayed:

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

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.

Rearrange Workspace Columns

To rearrange workspace columns:

1. In the workspace in which you are working, click the Grid tab.
2. Click Columns.
3. 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.
4. To rearrange the column order, click More on the Columns drop down.
5. Click Add to add a column, or click Remove to remove a column.
6. 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.
7. Click OK to save the column order changes or click Cancel to revert to the original column order.
8. To clear all custom settings, click Restore Defaults.

Freeze/Unfreeze Columns

To freeze/unfreeze workspace columns:

1. In the workspace in which you are working, click the Grid tab.
2. Click Freeze Columns.
3. Place the cursor in a data column and select Freeze Selected Columns to freeze that column or select Freeze First Column to freeze the first displayed column in the workspace.
4. To unfreeze, click Unfreeze Panes on the ribbon.
5. To clear all custom settings, click Restore Defaults.

Sort Columns

To sort workspace columns:

1. In the workspace in which you are working, click the Grid tab.
2. Click Custom.
3. In the Sort dialog box, if there are no existing columns, click the Define columns to sort by link.
   
4. Click the Sort item by drop down and select a column. Click the Ascending/Descending drop down and select a sort order.
5. Click to add additional sort levels. Click to delete sort levels.
6. Click Save to save the sort options.
7. To clear all custom settings, click Restore Defaults.

Display Row Numbers and Vertical Lines

To display row numbers and vertical lines:

1. In the workspace in which you are working, click the Grid tab.
   
2. Click to select a row in the workspace and click the Show drop down.
3. Click Row Numbers to toggle the display of numbers for all workspace rows.
4. Click Vertical Gridlines to toggle the display of vertical lines between workspace columns.

View Row Details

To view row details:

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 Up and Down arrows.