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

Block, Functions

Page 122 highlights

All Off This function is used to reset all the attributes of the selected cells to their default settings (underline off, bold off, fixed auto decimal, currency and percent off, no commas, formula text off, no display off). 1. Move the cursor to a corner of the range of cells that you want to reset and press MENU and select Style; then select All Off from the function menu. 2. Proceed as you would with the Underline function to select the range of cells. After the range is selected, the All Off window appears. OK to delete format? Use cursor to select and press RETURN. I E5 [NO] • YES: Deletes all the Style settings and restores the default settings in the selected range. • NO: Cancels the function and returns to the previous display. Block Functions Style FIN Sliee[ Option Mae Copy(A Range of Cells) Copy(One Cell Is Olher Cells) Clear Copy to Clip Board Pill; from Clip Board You can press CANCEL at any time to cancel the function. The Block operations will move the Style settings of the individual cells with the cells. Use the Block functions from the function menu to modify the location of an entire range of cells: Move: Moves a range of cells to another location. The original location is left empty. Copy (A Range of Cells): Copies a range of cells to another location. The original lot-adult is left unchanged. Copy (One Cell to Other Cells): Copies one cell to all the cells in a range. Clear: Empties all cells in a range. Copy to Clip Board: Copies a range of cells to the Clip Board. Paste from Clip Board: Pastes the contents of the Clip Board into the worksheet. Absolute and relative addresses Whenever the layout of your spreadsheet is altered, and the data within a cell has been copied, the cell reference in the formulas are updated accordingly. A cell with a relative address will be updated to reflect most layout changes. A cell with an absolute address is generally not updated when you change the layout. However, there may be times that you do not wish the cell address in the formula updated. Cell addresses are considered relative, unless a $ (dollar sign) is placed at the beginning of the cell address in the formula: Al is a relative address; $Al is an absolute address. Spreadsheet 114

  • 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

All
Off
This
function
is
used
to
reset
all
the
attributes
of
the
selected
cells
to
their
default
settings
(underline
off,
bold
off,
fixed
auto
decimal,
currency
and
percent
off,
no
commas,
formula
text
off,
no
display
off).
1.
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
reset
and
press
MENU
and
select
Style;
then
select
All
Off
from
the
function
menu.
2.
Proceed
as
you
would
with
the
Underline
function
to
select
the
range
of
cells.
After
the
range
is
selected,
the
All
Off
window
appears.
Block
Functions
Style
FIN
Sliee[
Option
Mae
Copy(A
Range
of
Cells)
Copy(One
Cell
Is
Olher
Cells)
Clear
Copy
to
Clip
Board
Pill;
from
Clip
Board
You
can
press
CANCEL
at
any
time
to
cancel
the
function.
The
Block
operations
will
move
the
Style
settings
of
the
individual
cells
with
the
cells.
OK
to
delete
format?
Use
cursor
to
select
and
press
RETURN.
I
E5
[NO]
YES:
Deletes
all
the
Style
settings
and
restores
the
default
settings
in
the
selected
range.
NO:
Cancels
the
function
and
returns
to
the
previous
display.
Use
the
Block
functions
from
the
function
menu
to
modify
the
location
of
an
entire
range
of
cells:
Move:
Moves
a
range
of
cells
to
another
location.
The
original
location
is
left
empty.
Copy
(A
Range
of
Cells):
Copies
a
range
of
cells
to
another
location.
The
original
lot
-adult
is
left
unchanged.
Copy
(One
Cell
to
Other
Cells):
Copies
one
cell
to
all
the
cells
in
a
range.
Clear:
Empties
all
cells
in
a
range.
Copy
to
Clip
Board:
Copies
a
range
of
cells
to
the
Clip
Board.
Paste
from
Clip
Board:
Pastes
the
contents
of
the
Clip
Board
into
the
worksheet.
Absolute
and
relative
addresses
Whenever
the
layout
of
your
spreadsheet
is
altered,
and
the
data
within
a
cell
has
been
copied,
the
cell
reference
in
the
formulas
are
updated
accordingly.
A
cell
with
a
relative
address
will
be
updated
to
reflect
most
layout
changes.
A
cell
with
an
absolute
address
is
generally
not
updated
when
you
change
the
layout.
However,
there
may
be
times
that
you
do
not
wish
the
cell
address
in
the
formula
updated.
Cell
addresses
are
considered
relative,
unless
a
$
(dollar
sign)
is
placed
at
the
beginning
of
the
cell
address
in
the
formula:
Al
is
a
relative
address;
$Al
is
an
absolute
address.
Spreadsheet
114