Brother International WP335B Owners Manual - English - Page 225

Freezing, Releasing, Leftmost, Columns, Screen

Page 225 highlights

NOTE: The fill function fills the markedrange from the upper-left corner down, then starting from the top of the second column, and so on. Three values are necessary: starting, jumping, and ending values. The starting value is written in the upper-left corner. Next numbers are calculated by adding the jumping value to the previously written value. Filling stops when the calculated value exceeds the ending value or when the marked range is filled, whichever comes first. 6_ Since June First is Saturday, enter -5 for the starting value. The word processor asks you to enter the jumping value and the ending value. Enter 1 for the jumping value and 30 for the ending value. The range fills when you press RETURN to enter the ending value. a :June ,-) :'4.:.: SUN :1:ig.5:,04;:4;:i :4... MON -4 3 $'. : : TUE -3 4 :,(!.::.: WED -2 5 7:.i THU -1 6 a.i FRI *.."SAT.':.:.-.,:': 0 7 1 8 P1TCH:10 9 16 23 30 10 17 24 11 18 25 12 19 26 13 20 27 14 21 28 15 22 29 7. Delete the contents of cells B3, B4, BS, B6, B7, and B8. Freezing and Releasing Leftmost Columns on the Screen Because this spreadsheet is wider than the display screen, you might find at some point that you wish to keep the first column(s) where you can see them while editing the rightmost columns. Freezing 1. Press MENU to display the function menu. RECALC SORT CLEAR CONVERT 2. Select COLUMN and press RETURN. This menu appears: WIDTH FILL OliEkik-!RELEASE 3. Select FREEZE and press RETURN. The word processor asks you to indicate the columns you want to frozen. This message appears: Move block cursor to right of columns to be frozen and press REITTRN. Spreadsheet 213

  • 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

NOTE:
The
fi
ll
function
fills
the
marked
range
from
the
upper
-left
corner
down,
then
starting
from
the
top
of
the
second
column,
and
so
on.
Three
values
are
necessary:
starting,
jumping,
and
ending
values.
The
starting
value
is
written
in
the
upper
-left
corner.
Next
numbers
are
calculated
by
adding
the
jumping
value
to
the
previously
written
value.
Filling
stops
when
the
calculated
value
exceeds
the
ending
value
or
when
the
marked
range
is
filled,
whichever
comes
fi
rst.
6_
Since
June
First
is
Saturday,
enter
—5
for
the
starting
value.
The
word
processor
asks
you
to
enter
the
jumping
value
and
the
ending
value.
Enter
1
for
the
jumping
value
and
30
for
the
ending
value.
The
range
fills
when
you
press
RETURN
to
enter
the
ending
value.
a
:June
,-)
P1TCH:10
:'4
.:.
:
SUN
:1:ig.5:,04;:4;
i
:
9
16
23
30
:4...
MON
-4
3
10
17
24
$'.
: :
TUE
-3
4
11
18
25
:,(!.::.:
WED
-2
5
12
19
26
7:.i
THU
-1
6
13
20
27
a.i
FRI
0
7
14
21
28
*.."SAT.':.:
-
..
,
:':
1
8
15
22
29
7.
Delete
the
contents
of
cells
B3,
B4,
BS,
B6,
B7,
and
B8.
Freezing
and
Releasing
Leftmost
Columns
on
the
Screen
Because
this
spreadsheet
is
wider
than
the
display
screen,
you
might
find
at
some
point
that
you
wish
to
keep
the
first
column(s)
where
you
can
see
them
while
editing
the
rightmost
columns.
Freezing
1.
Press
MENU
to
display
the
function
menu.
RECALC
SORT
CLEAR
CONVERT
2.
Select
COLUMN
and
press
RETURN.
This
menu
appears:
WIDTH
FILL
OliEkik-!RELEASE
3.
Select
FREEZE
and
press
RETURN.
The
word
processor
asks
you
to
indicate
the
columns
you
want
to
frozen.
This
message
appears:
Move
block
cursor
to
right
of
columns
to
be
frozen
and
press
REITTRN.
Spreadsheet
213