20060301
13-4-26
Editing Cell Contents
Searching for Data in a Spread
s
heet
The Search command helps you locate specific data in a spreadsheet quickly and easily.
I
Search Dialog Box
The Search command can be executed either by tapping [Search] on the [Edit] menu or by
tapping the
d
button on the toolbar. Executing the Search command displays a search
dialog box like the one shown below, along with a soft keyboard.
The following explains the meaning of each item on the search dialog box.
Item
De
s
cription
Search
Enter the character string, value, or expression you want to search
for. What you enter is called the “search string”.
Range
Specifies the range of cells to be searched.
Search by
Specifies whether the search should be line-by-line or column-by-
column.
Look in
Specifies whether values or formulas should be searched.
:h
Match Case
Select this check box to find exact matches, including uppercase
and lowercase characters, of what is specified in the [Search] box.
Clear the checkbox to search for matches, regardless of case.
:h
Match Entire Cell
Select this check box to find cells that contain only what is
specified in the [Search] box, and nothing else. Clear the check
box to find cells that contain what is specified in the [Search] box,
even if it is mixed with other data.
The following table shows a number of examples of what happens
for each of the [Match Entire Cell] settings when “bcd” is specified
in the [Search] box. “
G
” indicates that the cell is a match, while “
”
is not a match.
Cell Content
s
Not Selected
Selected
abcdef
G
bcd
G
G
bcdef
G
Summary of Contents for ClassPad 330
Page 11: ...20060301 20090601 ClassPad 330 ClassPad OS Version 3 04 ...
Page 277: ...20060301 3 3 10 Storing Functions 3 Tap AND Plot OR Plot ...
Page 779: ...20090601 S Graph Line Clustered C S Graph Line Stacked E 13 9 2 Graphing ...
Page 780: ...20090601 S Graph Line 100 Stacked F S Graph Column Clustered G 13 9 3 Graphing ...
Page 781: ...20090601 S Graph Column Stacked I S Graph Column 100 Stacked J 13 9 4 Graphing ...
Page 782: ...20090601 S Graph Bar Clustered K S Graph Bar Stacked 9 13 9 5 Graphing ...