User`s guide

E-Prime User’s Guide
Chapter 5: Data Handling
Page 182
Figure 1. Columns to be removed are selected.
Figure 2. The selected columns are moved to the “Hide
these columns” side of the dialog by clicking the Remove
button.
When the OK button is clicked, the columns in the left list will be removed from the display. The
columns to be displayed may be reordered by using the Move Up or Move Down buttons below
the list.
A useful feature for selecting columns within the Arrange Columns dialog is the Select button
(bottom left). The field to the right of the Select button is used to enter a filter criterion with which
to select column names. Filters can include the “*” wildcard symbol, and multiple filters may be
entered, separated by a semicolon. Click the Select button to automatically select, or highlight,
these columns in the dialog. For example, it is frequently useful to hide all columns that pertain to
the List and Procedure objects. Therefore, a convenient filter to use in the Arrange Columns
dialog would be “*List*; Running*; Procedure*.” Enter this filter and click the Select button to
select all columns matching this filter. Click the Remove button to move the selected columns to
the “Hide these columns” list.
The resulting display is a more manageable and concise spreadsheet, allowing the user to focus
on the most important data. Another useful method of narrowing the display of data in the
spreadsheet is to first Remove All columns to the “Hide these columns” list, and then to replace
(i.e., move back to the Show column) only those columns of interest. For example, to look at only
the data related to the input collected by the Target object, click the Remove All button, enter the
“Target*” filter, click the Select button to select all variables related to the Target object, and click
the Add button. The resulting display will narrow the spreadsheet to only data relevant to the
target. These methods allow the user to quickly focus on the relevant data.