Brother International WP1700MDS Owners Manual - English - Page 215

Freezing, Releasing, Leftmost, Columns, Screen

Page 215 highlights

SPREADSHEE NOTE: The fill function will fill 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 first. 6. Since June First is Friday, enter -4 for the starting value. The word processor will ask you to enter the jumping value and the ending value. Enter 1 for the jumping value and 30 for the ending value. The range will be automatically filled when you press to enter the ending value. 11. 1.Wpir June SUN MON -3 TUE -2 u WED -1 THU 0 Ti FRI -11 SAT 3 10 17 24 4 11 18 25 5 12 19 26 G 13 20 27 7 14 21 28 8 15 22 29 9 16 23 30 PTTCH:1 n 7. Delete the contents of cells B3, B4, B5, B6, and B7. 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 NM to display the function menu. O' W FORMAT RECALC SORT CLEAR CONVERT 2. Select COLUMN, and press 171 . This menu will appear: WIDTH FILL RELEASE 3. Select FREEZE and press gipW. The system asks you to indicate the columns to be frozen. This message will appear: 205

  • 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

NOTE:
The
fill
function
will
fill
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
first.
6.
Since
June
First
is
Friday,
enter
-4
for
the
starting
value.
The
word
processor
will
ask
you
to
enter
the
jumping
value
and
the
ending
value.
Enter
1
for
the
jumping
value
and
30
for
the
ending
value.
The
range
will
be
automatically
filled
when
you
press
to
enter
the
ending
value.
11
.
1
.Wpir
June
PTTCH:1
n
SUN
3
10
17
24
MON
-3
4
11
18
25
TUE
-2
5
12
19
26
u
WED
-1
G
13
20
27
THU
0
7
14
21
28
Ti
FRI
8
15
22
29
-1
1
SAT
9
16
23
30
7.
Delete
the
contents
of
cells
B3, B4, B5,
B6,
and
B7.
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
NM
to
display
the
function
menu.
O'
W
FORMAT
RECALC
SORT
CLEAR
CONVERT
2.
Select
COLUMN,
and
press
1
7
1
.
This
menu
will
appear:
WIDTH
FILL
RELEASE
3.
Select
FREEZE
and
press
gipW.
The
system
asks
you
to
indicate
the
col-
umns
to
be
frozen.
This
message
will
appear:
205
SPREADSHEE