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

Editing, Copying, the Contents of a Cell, and Moving Information

Page 170 highlights

Editing the Contents of a Cell Typically, you will need to modify entries you make in a spreadsheet, whether to correct an error you have made or to update the spreadsheet to reflect new information. If it is a simple change, you can select the cell to make it active and then type the new entry. If you want to make a change in a complex entry, you may want to work in the Edit Bar. You can also press CODE+SPACEBAR to begin editing the selected cell. "To edit the contents of a cell: 1. Select the cell you want to change. 2. In the Edit Area, select the information you want to change, or click where you want to insert new information. 3. Make the corrections you want. 4. To confirm your changes, click on Enter or press ENTER. OR Occasionally, you may want to delete the contents of one or more cells. You can delete information permanently, or you can transfer it to the clipboard so you can then move it to another location. To cancel the changes, click the Restore button (see page 140) or press ESC. "To delete the contents of cells: 1. Select the cell or range of cells whose contents you want to delete. 2. Press DELETE. The contents of the cell or range are permanentlydeleted. OR If you accidentally delete the wrong information using the DELETE key or the Delete choice on the Edit menu, you cannot restore the deleted information. You may want to delete information using the Cut choice on the Edit menu; that way, if you accidentally delete the wrong information, you can paste it back in place. Choose Delete from the Edit menu. The contents of the cell or range are permanently deleted. OR Choose Cut from the Edit menu or press CUT. The contents of the cell or range are transferred to the clipboard; you can use the Paste choice on the Edit menu to copy the cell or range to another location. Copying and Moving Information As you work with Spreadsheet, you may find it convenient to copy and move information. There are two ways to copy and move information in Spreadsheet: S You can use the Fill choices on the Cell menu to copy the contents of the active cell across a row or down a column. S You can use the Cut, Copy, and Paste choices on the Edit menu to copy or move information to any other location in a spreadsheet. Or, you can click the tools on the Advanced Functions tool bar, if displayed. S You can use the CUT, COPY, and PASTE keys to copy or move information to any other location in a spreadsheet. Spreadsheet 156

  • 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
156
Editing
the Contents of a Cell
Typically, you will need to modify entries you make in a spreadsheet,
whether to correct an error you have made or to update the spreadsheet
to reflect new information. If it is a simple change, you can select the cell
to make it active and then type the new entry. If you want to make a
change in a complex entry, you may want to work in the Edit Bar.
"
To edit the contents of a cell:
1. Select the cell you want to change.
2. In the Edit Area, select the information you want to change, or click
where you want to insert new information.
3. Make the corrections you want.
4. To confirm your changes, click on Enter or press
ENTER
.
OR
To cancel the changes, click the Restore button (see page 140) or
press
ESC
.
"
To delete the contents of cells:
1. Select the cell or range of cells whose contents you want to delete.
2. Press
DELETE
.
The contents of the cell or range are permanentlydeleted.
OR
Choose
Delete
from the Edit menu.
The contents of the cell or range
are permanently deleted.
OR
Choose Cut from the Edit menu or press
CUT
.
The contents of the
cell or range are transferred to the clipboard; you can use the Paste
choice on the Edit menu to copy the cell or range to another location.
Copying
and Moving Information
As you work with Spreadsheet, you may find it convenient to copy and
move information. There are two ways to copy and move information in
Spreadsheet:
S
You can use the Fill choices on the Cell menu to copy the contents of
the active cell across a row or down a column.
S
You can use the Cut, Copy, and Paste choices on the Edit menu to
copy or move information to any other location in a spreadsheet. Or,
you can click the tools on the Advanced Functions tool bar, if
displayed.
S
You can use the
CUT
,
COPY
, and
PASTE
keys to copy or move
information to any other location in a spreadsheet.
You
can also press
CODE
+
SPACEBAR
to begin
editing the selected cell.
Occasionally
, you may want to
delete the contents of one or
more cells. Y
ou can delete
information permanently
, or you
can transfer it to the clipboard so
you can then move it to another
location.
If you accidentally delete the wrong
information using the
DELETE
key
or the Delete choice on the Edit
menu, you cannot restore the
deleted information. Y
ou may want to
delete information using the Cut
choice on the Edit menu; that way
, if
you accidentally delete the wrong
information, you can paste it back in
place.