User`s guide

E-Prime User’s Guide
Chapter 5: Data Handling
Page 185
Visual Cues
The spreadsheet provides a number of visual cues to remind the user that filters have been
applied to the displayed data. First, filtered columns have white column headers rather than gray,
and rows are numbered non-consecutively.
Below the spreadsheet, the Filter Bar, labeled “Filters,” displays the current filters. At the bottom
of the display, the Status Bar displays the number of unhidden rows.
The Rows Displayed value is a quick method of determining that all of the data is present, and/or
whether a filter has been applied. When a data file is opened, the Rows Displayed number will
always equal the total number of rows in the data file because filters are not saved when the file
is closed.
Clear Filters
A filter may be cleared using E-DataAid’s Filter command on the Tools menu. Activating this
command displays the Filter dialog. Which lists the current filters applied to the spreadsheet. To
clear a filter, simply select the filter in the list and click the Clear button. To clear all filters, use
the Clear All button.