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

Title, CURSOR, SPACE, RETURN, Spreadsheet

Page 128 highlights

Title This function freezes the first rows/columns of a large worksheet so that the titles they contain are always visible when you scroll the sheet. 1. Press MENU and select Sheet; then select Title from the function menu. The TITLE window appears: •t< TITLE >> TITLE FREEZE OR RELEASE: DIRECTION: UMW COLUMNS Press SPACE to change setting and press RETURN. 2. Use CURSOR UP and CURSOR DOWN to move the cursor to the desired setting. Use SPACE BAR to change the settings. • TITLE FREEZE OR RELEASE : FREEZE Freezes column(s) or row(s). • TITLE FREEZE OR RELEASE : RELEASE Releases frozen columns or rows. • DIRECTION : COLUMNS Applies the change to column(s) only. • DIRECTION : ROWS Applies the change to row(s) only. • DIRECTION : BOTH Applies the change to both column(s) and row(s). 3. Press RETURN when finished. Ifyou selected TITLE FREEZE OR RELEASE: RELEASE, thefrozen column(s), rows) or both are released and this message appears: Frozen columns/rows have been released. Ifyou selected TITLEFREEZE OR RELEASE: FREEZE, this message appears: Move cursor to right of the columns/one row below the rows to be frozen and press RETURN. 4. To freeze columns, move the cursor to the right of the last column to be frozen (if you want to freeze columns A and B, move cursor to column C). To freeze rows, move the cursor one row below the last row to be frozen (if you want to freeze rows 1 and 2, move cursor to row 3). To freeze both columns and rows, combine the procedures for columns and rows (if you want to freeze column A and row 1, move the cursor to cell B2). 5. Press RETURN when selection is complete. • You cannot freeze rows when displaying two files at a time (Dual screen mode). If switch to the dualscreen mode while rows arefrozen, they will be automatically released and this message will appear when you switch between files with the Change Screen command: Frozen rows have been released. Spreadsheet 120

  • 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

Title
This
function
freezes
the
first
rows/columns
of
a
large
worksheet
so
that
the
titles
they
contain
are
always
visible
when
you
scroll
the
sheet.
1.
Press
MENU
and
select
Sheet;
then
select
Title
from
the
function
menu.
The
TITLE
window
appears:
•t<
TITLE
>>
TITLE
FREEZE
OR
RELEASE:
DIRECTION:
UMW
COLUMNS
Press
SPACE
to
change
setting
and
press
RETURN.
2.
Use
CURSOR
UP
and
CURSOR
DOWN
to
move
the
cursor
to
the
desired
setting.
Use
SPACE
BAR
to
change
the
settings.
TITLE
FREEZE
OR
RELEASE
:
FREEZE
Freezes
column(s)
or
row(s).
TITLE
FREEZE
OR
RELEASE
:
RELEASE
Releases
frozen
columns
or
rows.
DIRECTION
:
COLUMNS
Applies
the
change
to
column(s)
only.
DIRECTION
:
ROWS
Applies
the
change
to
row(s)
only.
DIRECTION
:
BOTH
Applies
the
change
to
both
column(s)
and
row(s).
3.
Press
RETURN
when
finished.
If
you
selected
TITLE
FREEZE
OR
RELEASE:
RELEASE,
the
frozen
column(s),
rows)
or
both
are
released
and
this
message
appears:
Frozen columns/rows
have
been
released.
If
you
selected
TITLE
FREEZE
OR
RELEASE
:
FREEZE,
this
message
appears:
Move
cursor
to
right
of
the
columns/one
row
below
the
rows
to
be
frozen
and
press
RETURN.
4.
To
freeze
columns,
move
the
cursor
to
the
right
of
the
last
column
to
be
frozen
(if
you
want
to
freeze
columns
A
and
B,
move
cursor
to
column
C).
To
freeze
rows,
move
the
cursor
one
row
below
the
last
row
to
be
frozen
(if
you
want
to
freeze
rows
1
and
2,
move
cursor
to
row
3).
To
freeze
both
columns
and
rows,
combine
the
procedures
for
columns
and
rows
(if
you
want
to
freeze
column
A
and
row
1,
move
the
cursor
to
cell
B2).
5.
Press
RETURN
when
selection
is
complete.
You
cannot
freeze
rows
when
displaying
two
files
at
a
time
(Dual
screen
mode).
If
switch
to
the
dual
screen
mode
while
rows
are
frozen,
they
will
be
automatically
released
and
this
message
will
appear
when
you
switch
between
files
with
the
Change
Screen
command:
Frozen
rows
have
been
released.
Spreadsheet
120