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

and Deleting Rows and Columns, Inserting

Page 173 highlights

3. Drag the pointer so that it is over the first cell where you want to move or copy the information. 4. Release the mouse button. The information is moved or copied, depending on whether you dragged within the same document or from one document to another. As you position the drag and drop pointer, the small square at the end of the pointer changes to indicate whether this will be a move or a copy. Inserting and Deleting Rows and Columns After you have created a spreadsheet, you may need to add a row or column to make room for additional information. When information becomes obsolete, you will want to delete a row or column. For multiple additions or deletions, repeat this procedure as needed. You can add and delete multiple rows and columns. "To insert a row or column: 1. Select a cell where you want the insertion to occur. Rows are inserted above the active cell, columns to the left of the active cell. 2. Choose Insert Row/Column from the Edit menu. A dialog box appears. 3. Select either Row or Column in the dialog box. 4. Click on Insert. "To quickly insert a row or column: 1. Select a cell where you want the insertion to occur. 2. Click the Insert Row tool on the Basic Functions tool bar. OR Click the Insert Column tool on the Basic Functions tool bar. Inserting and deleting cannot take place for rows, columns, and cells which are entirely within a locked area. "To delete a row or column: 1. Select a cell in the row or column you want to delete. 2. Choose Delete Row/Column from the Edit menu. A dialog box appears. 3. Select either Row or Column in the dialog box. 4. Click on Delete. "To quickly delete a row or column: 1. Select a cell in the row or column you want to delete. 2. Click on the Delete Row tool on the Basic Functions tool bar. OR Click on the Delete Column tool on the Basic Functions tool bar. Spreadsheet 159

  • 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
159
3. Drag the pointer so that it is over the first cell where you want to move or
copy the information.
4. Release the mouse button.
The information is moved or copied,
depending on whether you dragged within the same document or from
one document to another.
As you position the drag and drop pointer, the small square at the end of
the pointer changes to indicate whether this will be a move or a copy.
Inserting
and Deleting Rows and Columns
After you have created a spreadsheet, you may need to add a row or
column to make room for additional information. When information
becomes obsolete, you will want to delete a row or column.
"
To insert a row or column:
1. Select a cell where you want the insertion to occur. Rows are inserted
above
the active cell, columns to the
left
of the active cell.
2. Choose Insert Row/Column from the Edit menu.
A dialog box appears.
3. Select either Row or Column in the dialog box.
4. Click on Insert.
"
To quickly insert a row or column:
1. Select a cell where you want the insertion to occur.
2. Click the Insert Row tool on the Basic Functions tool bar.
OR
Click the Insert Column tool on the Basic Functions tool bar.
"
To delete a row or column:
1. Select a cell in the row or column you want to delete.
2. Choose Delete Row/Column from the Edit menu.
A dialog box appears.
3. Select either Row or Column in the dialog box.
4. Click on Delete.
"
To quickly delete a row or column:
1. Select a cell in the row or column you want to delete.
2. Click on the Delete Row tool on the Basic Functions tool bar.
OR
Click on the Delete Column tool on the Basic Functions tool bar.
For
multiple additions or
deletions, repeat this procedure
as needed. Y
ou can add and
delete multiple rows and columns.
Inserting and deleting cannot take
place for rows, columns, and
cells which are entirely within a
locked area.