Brother International WP7550JPLUS Owner's Manual - English - Page 114

Select

Page 114 highlights

When a column that is selected for primary or secondary sort contains different types of cells, -the sort order is: Empty cell < Numeric < Alphanumeric < ERROR cell, This sorting function can perform a double sort, primary and secondary. A typical example of double sorting is when you have data related to people. You can use the family name for primary sort, and the first name for secondary sort. 2. Move the cursor to the primary sort column and press RETURN. This message appears: Move cursor to secondary sort column and press RETURN. 3. Move the cursor to the secondary sort column and press RETURN. If you do not need a secondary sort, leave the cursor on the primary sort column. The Direction window appears: Direction? Use cursor to select and press RETURN. [P.!-Z,LENIDI N14:i] [DESCENDING), [CANCEL] 4. Use CURSOR LEFT and CURSOR RIGHT to select ASCENDING, DESCENDING, or CANCEL and press RETURN to sort. • ASCENDING: Normal alphabcdc order fur alphanumeric_ data, increasing values for numeric data (A-Z and 1-100). • DESCENDING: Reverse alphabetic order for alphanumeric data, decreasing values for numeric data (Z-A and 100-1). • CANCEL: Cancels the function and returns to the previous display. Select This function is used to select rows of data that match a specified condition. The data can be displayed, written in the current worksheet, and printed. 1. Move the cursor to a corner of the range of cells that you want to select and press MENU and select Edit; then choose Select from the function menu. Ifyou have not recalculated the spreadsheet since changing any ofthe cells contents, then thefollowing message will appear. The sheet needs recalculation. Recalculate? Use cursor to select and press RETURN. (NEC] Select YES and press RETURN. OR If the spreadsheet has not been changed sinces the last recalculation. The system asks you to specii5, the range. Proceed as with the Left function. After the range is specified, an arrow cursor appears above the worksheet. A message will ask you to move the arrow cursor to select a columnfor the range. Move cursor to select column and press RETURN. Spreadsheet 106

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252

This
sorting
function
can
perform
a
double
sort,
primary
and
secondary.
A
typical
example
of
double
sorting
is
when
you
have
data
related
to
people.
You
can
use
the
family
name
for
primary
sort,
and
the
first
name
for
secondary
sort.
2.
Move
the
cursor
to
the
primary
sort
column
and
press
RETURN.
This
message
appears:
Move
cursor
to
secondary
sort
column
and
press
RETURN.
3.
Move
the
cursor
to
the
secondary
sort
column
and
press
RETURN.
If
you
do
not
need
a
secondary
sort,
leave
the
cursor
on
the
primary
sort
column.
The
Direction
window
appears:
When
a
column
that
is
selected
for
primary
or
secondary
sort
contains
different
types
of
cells,
-
the
sort
order
is:
Empty
cell
<
Numeric
<
Alphanumeric
<
ERROR
cell,
Select
Direction?
Use
cursor
to
select
and
press
RETURN.
[P.!-Z,LENIDI
N
14:i]
[DESCENDING),
[CANCEL]
4.
Use
CURSOR
LEFT
and
CURSOR
RIGHT
to
select
ASCENDING,
DESCENDING,
or
CANCEL
and
press
RETURN
to
sort.
ASCENDING:
Normal
alphabcdc
order
fur
alphanumeric_
data,
increasing
values
for
numeric
data
(A
—Z
and
1-100).
DESCENDING:
Reverse
alphabetic
order
for
alphanumeric
data,
decreasing
values
for
numeric
data
(Z
—A
and
100-1).
CANCEL:
Cancels
the
function
and
returns
to
the
previous
display.
This
function
is
used
to
select
rows
of
data
that
match
a
specified
condition.
The
data
can
be
displayed,
written
in
the
current
worksheet,
and
printed.
1.
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
select
and
press
MENU
and
select
Edit;
then
choose
Select
from
the
function
menu.
If
you
have
not
recalculated
the
spreadsheet
since
changing
any
of
the
cells
contents,
then
the
following
message
will
appear.
The
sheet
needs
recalculation.
Recalculate?
Use
cursor
to
select
and
press
RETURN.
(NEC]
Select
YES
and
press
RETURN.
OR
If
the
spreadsheet
has
not
been
changed
sinces
the
last
recalculation.
The
system
asks
you
to
specii5,
the
range.
Proceed
as
with
the
Left
function.
After
the
range
is
specified,
an
arrow
cursor
appears
above
the
worksheet.
A
message
will
ask
you
to
move
the
arrow
cursor
to
select
a
column
for
the
range.
Move
cursor
to
select
column
and
press
RETURN.
Spreadsheet
106