Brother International PDP350CJ Owner's Manual - English - Page 172

Using Cut, Copy, and Paste, Using Drag and Drop, To copy or move information

Page 172 highlights

2. Choose Fill Down from the Cell menu to copy the formula to the selected cells beneath it. OR Choose Fill Right from Cell menu to copy the formula to the selected cells to its right. The formula appears in the new locations. Copied formulas Using Cut, Copy, and Paste For more information about the clipboard or using these menu choices, see "Selecting and Editing" in Getting Started. Using these menu choices, you can copy or move a single cell or a range of cells to any other location in a spreadsheet. Cut, Copy, and Paste work the same way in Spreadsheet as they do in other applications. Cut and Copy places the selected cells on the clipboard; Paste retrieves any previously cut or copied information from the clipboard. "To copy or move information: 1. Select the cell, range, row(s), or column(s) you want to copy or move. 2. To copy the selection, choose Copy from the Edit menu or press COPY; to move it, choose Cut from the Edit menu or press CUT. 3. Select the first cell where you want to copy or move the information. 4. Choose Paste from the Edit menu or press PASTE. The values and formulas appear in the new location with the first cell of the copied selectionappearing in the destination cell. Using Drag and Drop You can override the default drag and drop by holding down the CODE key if you want to copy within a document or the MENU key if you want to move text from one document to another. You can use drag and drop to move or copy cells in your spreadsheet. Drag and drop works the same way in Spreadsheet as it does in other applications. If you drag and drop within the same document, the default behavior is to move the information. If you drag and drop from one document to another, the default behavior is to copy. "To drag and drop information from one location to another: 1. Select the cell, range, row(s), or column(s) you want to move or copy. 2. Move the mouse pointer over the selected range; then press and hold down the right mouse button. The drag and drop pointer appears. Spreadsheet 158

  • 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
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332
  • 333
  • 334
  • 335
  • 336
  • 337
  • 338
  • 339
  • 340
  • 341
  • 342
  • 343
  • 344
  • 345
  • 346
  • 347
  • 348
  • 349
  • 350
  • 351
  • 352
  • 353
  • 354
  • 355
  • 356
  • 357
  • 358
  • 359
  • 360
  • 361
  • 362
  • 363
  • 364
  • 365
  • 366
  • 367
  • 368
  • 369
  • 370
  • 371
  • 372
  • 373
  • 374
  • 375
  • 376
  • 377
  • 378
  • 379
  • 380
  • 381
  • 382
  • 383
  • 384
  • 385
  • 386
  • 387
  • 388
  • 389
  • 390
  • 391
  • 392
  • 393
  • 394
  • 395
  • 396
  • 397
  • 398
  • 399
  • 400
  • 401
  • 402
  • 403
  • 404
  • 405
  • 406
  • 407
  • 408
  • 409
  • 410
  • 411
  • 412
  • 413
  • 414
  • 415
  • 416
  • 417
  • 418
  • 419
  • 420
  • 421
  • 422
  • 423
  • 424
  • 425
  • 426
  • 427
  • 428
  • 429
  • 430
  • 431
  • 432
  • 433
  • 434
  • 435
  • 436
  • 437
  • 438
  • 439
  • 440

Spreadsheet
158
2. Choose Fill Down from the Cell menu to copy the formula to the
selected cells beneath it.
OR
Choose Fill Right from Cell menu to copy the formula to the
selected cells to its right.
The formula appears in the new locations.
Copied formulas
Using Cut, Copy, and Paste
Using these menu choices, you can copy or move a single cell or a range
of cells to any other location in a spreadsheet. Cut, Copy, and Paste work
the same way in Spreadsheet as they do in other applications. Cut and
Copy places the selected cells on the clipboard; Paste retrieves any
previously cut or copied information from the clipboard.
"
To copy or move information:
1. Select the cell, range, row(s), or column(s) you want to copy or move.
2. To copy the selection, choose Copy from the Edit menu or press
COPY
;
to move it, choose Cut from the Edit menu or press
CUT
.
3. Select the first cell where you want to copy or move the information.
4. Choose Paste from the Edit menu or press
PASTE
.
The values and
formulas appear in the new location with the first cell of the copied
selection appearing in the destination cell.
Using Drag and Drop
You can use drag and drop to move or copy cells in your spreadsheet.
Drag and drop works the same way in Spreadsheet as it does in other
applications. If you drag and drop within the same document, the default
behavior is to move the information. If you drag and drop from one
document to another, the default behavior is to copy.
"
To drag and drop information from one location to another:
1. Select the cell, range, row(s), or column(s) you want to move or copy.
2. Move the mouse pointer over the selected range; then press and hold
down the right mouse button.
The drag and drop pointer appears.
For
more information about the
clipboard or using these menu
choices, see “Selecting and
Editing” in Getting Started.
Y
ou can override the default drag
and drop by holding down the
CODE
key if you want to copy
within a document or the
MENU
key if you want to move text from
one document to another
.