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

Sheet, Functions

Get Brother International WP7550JPLUS PDF manuals and user guides View all Brother International WP7550JPLUS manuals
Add to My Manuals
Save this manual to your list of manuals

Page 126 highlights

Sheet Functions Block MSS Option S 0DIurnn Title Insert Delete Recalc Range Protect Worksheet Protect Calculation Method When columns or rows are inserted or deleted from the worksheet, cells are renumbered. You can press CANCEL at any time to cancel these functions. Use the Sheet functions to adjust the width of columns, freeze, insert or remove rows and columns, recalculate the results of formulas and protect important parts of the worksheet. Column Width: Changes the width of columns. Tide: Freezes column(s) or row(s) on the screen so that the labels they contain are always visible when you scroll the worksheet. The same function is used to release frozen columns or rows. Insert: Inserts blank rows or columns in the middle of the worksheet. Delete: Removes columns or rows from the worksheet. Recalc: Updates the results of all formulas. Range Protect: Protects a range of cells against accidental deleting or overwriting. The same function is used to remove the protection. Worksheet Protect: Enables or disables the protection of a range of cells from accidental deleting or overwriting. Calculation Method: Changes the method of calculation. Column Width This function is used to change the width of columns. It applies to the whole selected column, from the top to the bottom of the worksheet. 1. Move the cursor to the left most or right most column you want to change the width of and press MENU and select Sheet; then select Column Width from the function menu. The COLUMN WIDTH window appears: HOW?: WHERE?: « COLUMN WIDTH >> BEHMEN CHOICE 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. • HOW? : MANUAL Allows for manual setting of the width (you will have to enter a value for the width). • HOW? : AUTO Allows for automatic setting of the width (the width will be set automatically so that the longest entry of the selected column(s) can fit). • HOW? : DEFAULT Resets the width to 10 (default value). • WHERE? : CHOICE Applies the change to specified column(s) only. • WHERE? : GLOBAL Applies the change to the whole worksheet. 3. Press RETURN when finished. Spreadsheet 118

  • 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
Sheet
Functions
Block
MSS
Option
S
0DIurnn
Title
Insert
Delete
Recalc
Range
Protect
Worksheet
Protect
Calculation
Method
When
columns
or
rows
are
inserted
or
deleted
from
the
worksheet,
cells
are
renumbered.
You
can
press
CANCEL
at
any
time
to
cancel
these
functions.
Column
Width
Use
the
Sheet
functions
to
adjust
the
width
of
columns,
freeze,
insert
or
remove
rows
and
columns,
recalculate
the
results
of
formulas
and
protect
important
parts
of
the
worksheet.
Column
Width:
Changes
the
width
of
columns.
Tide:
Freezes
column(s)
or
row(s)
on
the
screen
so
that
the
labels
they
contain
are
always
visible
when
you
scroll
the
worksheet.
The
same
function
is
used
to
release
frozen
columns
or
rows.
Insert:
Inserts
blank
rows
or
columns
in
the
middle
of
the
worksheet.
Delete:
Removes
columns
or
rows
from
the
worksheet.
Recalc:
Updates
the
results
of
all
formulas.
Range
Protect:
Protects
a
range
of
cells
against
accidental
deleting
or
overwriting.
The
same
function
is
used
to
remove
the
protection.
Worksheet
Protect:
Enables
or
disables
the
protection
of
a
range
of
cells
from
accidental
deleting
or
overwriting.
Calculation
Method:
Changes
the
method
of
calculation.
This
function
is
used
to
change
the
width
of
columns.
It
applies
to
the
whole
selected
column,
from
the
top
to
the
bottom
of
the
worksheet.
1.
Move
the
cursor
to
the
left
most
or
right
most
column
you
want
to
change
the
width
of
and
press
MENU
and
select
Sheet;
then
select
Column
Width
from
the
function
menu.
The
COLUMN
WIDTH
window
appears:
HOW?:
WHERE?:
«
COLUMN
WIDTH
>>
BEHMEN
CHOICE
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.
•
HOW?
:
MANUAL
Allows
for
manual
setting
of
the
width
(you
will
have
to
enter
a
value
for
the
width).
•
HOW?
:
AUTO
Allows
for
automatic
setting
of
the
width
(the
width
will
be
set
automatically
so
that
the
longest
entry
of
the
selected
column(s)
can
fit).
•
HOW?
:
DEFAULT
Resets
the
width
to
10
(default
value).
•
WHERE?
:
CHOICE
Applies
the
change
to
specified
column(s)
only.
•
WHERE?
:
GLOBAL
Applies
the
change
to
the
whole
worksheet.
3.
Press
RETURN
when
fi
nished.
Spreadsheet
118