Brother International WP230B Owners Manual - English - Page 229

Organizing

Page 229 highlights

Organizing Your Data You can create text files as well as numbers and formulas_ The next example illustrates this. Sorting a Range When you update a file of names, addresses, and phone numbers, you usually add data at the end of the file. To make later reference easier, however, you need some logical organization. Alphabetical order is commonly used. The sorting feature shown here saves you time and effort in the organization of your data. To prepare: 1. Enter the data shown in the illustration: Marsh :„„ Anderson Jackson Bennet Higgins Carter Bender Higgins Fox Lee Henry John Howard William Ruth David William Joyce Terry Kevin Miamiburg OH Denver CO Stanford CA Westfield NJ Cambridge MA Dallas IX Freeport VT Atlanta GA Fremont CA Bedford TX 45342 82222 56904 28854 11000 76021 66622 30341 94537 76021 PITCH:10 2. If you want, make several copies of the data (using the copy function CODE + C) so that you can try several different types of sorts. You are now ready to go on with the first example: 1. Position the cursor on Al and press MENU to display the function menu. W4OCOLIMN FORMAT RECALC S0 '; CLEAR CONVERT 2. Select SORT and press RETURN. This menu appears: IV kiI/1 geigt. SELECT SORT & SELECT 3. Select SORT and press RETURN. This message appears: Mark range to be sorted. Press RETURN when done. Spreadsheet 217

  • 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
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332
  • 333
  • 334
  • 335
  • 336
  • 337
  • 338
  • 339
  • 340

Organizing
Your
Data
You
can
create
text
files
as
well
as
numbers
and
formulas_
The
next
example
illustrates
this.
Sorting
a
Range
When
you
update
a
file
of
names,
addresses,
and
phone
numbers,
you
usually
add
data
at
the
end
of
the
file.
To
make
later
reference
easier,
however,
you
need
some
logical
organization.
Alphabetical
order
is
commonly
used.
The
sorting
feature
shown
here
saves
you
time
and
effort
in
the
organization
of
your
data.
To
prepare:
1.
Enter
the
data
shown
in
the
illustration:
Marsh
:„„
PITCH:10
Henry
Miamiburg
OH
45342
Anderson
John
Denver
CO
82222
Jackson
Howard
Stanford
CA
56904
Bennet
William
Westfield
NJ
28854
Higgins
Ruth
Cambridge
MA
11000
Carter
David
Dallas
IX
76021
Bender
William
Freeport
VT
66622
Higgins
Joyce
Atlanta
GA
30341
Fox
Terry
Fremont
CA
94537
Lee
Kevin
Bedford
TX
76021
2.
If
you
want,
make
several
copies
of
the
data
(using
the
copy
function
CODE
+
C)
so
that
you
can
try
several
different
types
of
sorts.
You
are
now
ready
to
go
on
with
the
first
example:
1.
Position
the
cursor
on
Al
and
press
MENU
to
display
the
function
menu.
W4OCOLIMN
FORMAT
RECALC
S0
';
CLEAR
CONVERT
2.
Select
SORT
and
press
RETURN.
This
menu
appears:
IV
kiI/1
geigt.
SELECT
SORT
&
SELECT
3.
Select
SORT
and
press
RETURN.
This
message
appears:
Mark
range
to
be
sorted.
Press
RETURN
when
done.
Spreadsheet
217