Grids

This table shows the icons you can use to select and access records within a grid:

Icon	Description
	Select. After you select this check box, you can perform actions on the record, such as copy or edit.
	Drill down. Click to view the record.
	Expand/Collapse. Click to hide or show information contained in a row.
	Sort order. Indicates if the column is sorted by ascending or descending order.

Grid options

The grid options include the Export to Excel feature, Row Height options, and Filter options. You can access the grid options from the More menu.

Export to Excel

You can use this feature to export the contents of a grid to a Comma Separated Value (csv) file. You can open the CSV file in Microsoft Excel and save it as XLS or XLXS. The method that is used to save the spreadsheet depends on your spreadsheet application.

The columns in the spreadsheet are displayed in order they are displayed in the grid. Hidden columns are not included in the spreadsheet.

Row Height

You can select Short, Medium, or Normal in the More menu to change the height of the rows that display in the grid. The default value for this setting is Normal. If you change this value, it is not saved after you leave the function.

Show Filter Row

When you select Show Filter Row from the grid options list, a filter for each column is displayed in the grid header row. The type of filter available depends on the values in the column, for example, alpha, numerical, and date. Each type of filter offers several filter options, such as Contains, Starts With, and Equals. Select Clear Filter from the grid options list to delete the filter criteria.

Depending on your environment, the filter row for some grids might be displayed by default.

Grid pagination

You can select a Records Per Page value to change the number of records that are displayed per page.

When you select a Records per page value for a grid, that value becomes the default value for grids throughout the application, except grids in lookup windows. The default value is maintained after you sign out. If you change the default value, you must refresh other open functions to apply the new default value.

A separate default value is maintained for grids in lookup windows. Fewer records per page in a lookup window prevents excessive scrolling. The default value for lookup windows is also maintained after you sign out.

Keyboard shortcuts for grids

This table shows the keyboard shortcuts to navigate within the grid:

You can press Enter to change the edit mode of a cell. If the cell is equipped with control that uses a down arrow, then the control opens when you press Enter. Editable cells without controls switch to edit mode automatically when you specify a value or click in the cell. You are not required to press Enter.