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

range, cells

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 123 highlights

Move This function is used to move a range of cells to another location. The original cells are cleared. 1. Move the cursor to a corner of the range of cells that you want to move and press MENU and select Block; then select Move from the function menu. (Short cut: CODE + M. This message appears: Move cursor to end of block to be moved and press RETURN. 2. Move the cursor to the opposite corner of the range of cells that you want to move and press RETURN. This message appears: Move cursor to destination for blocked data and press RETURN. 3. Move the cursor to the upper left corner of the destination range and press RETURN. • If the new destination is such that the relocated data will exceed the limits of the worksheet, this message appears: Moue canceled. Range exceeds boundary of spreadsheet! Press any key to continue. • If the destination has protected cells (cells that you cannot erase or overwrite without first removing the protection) data transfer will be canceled and this message appears: Protected cell error! Press any key to continue. Copy (a range of cells) This function works like the move function except that the original range of cells is not cleared. 1. Move the cursor to a corner of the range of cells that you want to copy and press MENU and select Block; then select Copy (A Range of Cells) from the function menu. (Short cut CODE + C). This message appears: Move cursor to end of block to be copied and press RETURN. 2. Move the cursor to the opposite corner of the range of cells that you want to copy and press RETURN. This message appears: Move cursor to destination for blocked data and press RETURN. 3. Move the cursor to the upper left corner of the destination range and press RETURN. • If the new destination is such that the relocated data will exceed the limits of the worksheet, this message appears: Copy canceled. Range exceeds boundary of spreadsheet! Press any key to continue. Spreadsheet 115

  • 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
Move
This
function
is
used
to
move
a
range
of
cells
to
another
location.
The
original
cells
are
cleared.
1.
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
move
and
press
MENU
and
select
Block;
then
select
Move
from
the
function
menu.
(Short
cut:
CODE
+
M.
This
message
appears:
Move
cursor
to
end
of
block
to
be
moved
and
press
RETURN.
2.
Move
the
cursor
to
the
opposite
corner
of
the
range
of
cells
that
you
want
to
move
and
press
RETURN.
This
message
appears:
Move
cursor
to
destination
for
blocked
data
and
press
RETURN.
3.
Move
the
cursor
to
the
upper
left
corner
of
the
destination
range
and
press
RETURN.
•
If
the
new
destination
is
such
that
the
relocated
data
will
exceed
the
limits
of
the
worksheet,
this
message
appears:
Moue
canceled.
Range
exceeds
boundary
of
spreadsheet!
Press
any
key
to
continue.
•
If
the
destination
has
protected
cells
(cells
that
you
cannot
erase
or
overwrite
without
fi
rst
removing
the
protection)
data
transfer
will
be
canceled
and
this
message
appears:
Protected
cell
error!
Press
any
key
to
continue.
Copy
(a
range
of
cells)
This
function
works
like
the
move
function
except
that
the
original
range
of
cells
is
not
cleared.
1.
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
copy
and
press
MENU
and
select
Block;
then
select
Copy
(A
Range
of
Cells)
from
the
function
menu.
(Short
cut
CODE
+
C).
This
message
appears:
Move
cursor
to
end
of
block
to
be
copied
and
press
RETURN.
2.
Move
the
cursor
to
the
opposite
corner
of
the
range
of
cells
that
you
want
to
copy
and
press
RETURN.
This
message
appears:
Move
cursor
to
destination
for
blocked
data
and
press
RETURN.
3.
Move
the
cursor
to
the
upper
left
corner
of
the
destination
range
and
press
RETURN.
•
If
the
new
destination
is
such
that
the
relocated
data
will
exceed
the
limits
of
the
worksheet,
this
message
appears:
Copy
canceled.
Range
exceeds
boundary
of
spreadsheet!
Press
any
key
to
continue.
Spreadsheet
115