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

Changing Alignment, To set a row height manually, To change the alignment of cells

Page 176 highlights

4. Click on Apply to apply your changes. The dialog box remains on the screen until you close it, so that you can keep adjusting the width. 5. Click on Close to close the dialog box. Normally the height of each row adjusts automatically to accommodate the text size you use. However, you can manually change the row height if you want to use a different setting. "To set a row height manually: 1. Select the row for which you want to set the height. You can either click the row header or select a cell in the row. 2. Choose Row Height from the Cell menu. The dialog box at the left appears. 3. Click on the Automatic check box to turn off, and click inside the Height value selector. 4. Enter the number of points you want to use for the row height. 5. Click on Apply to apply your changes. The dialog box remains on the screen until you close it, so that you can keep adjusting the height. 6. Click on Close to close the dialog box when you are done adjusting the row height. Changing Alignment Usually, you want labels to line up at the left edge of a cell, and you want values to line up at the right edge. In other words, you want labels to be left-aligned, and you want values right-aligned. When you enter something in a cell, Spreadsheet automatically aligns it in this way. If you enter a formula, the result of the formula appears right-aligned. You can change justification by clicking a button on the Advanced Functions tool bar. "To change the alignment of cells: 1. Select the cells you want to align. 2. Choose Alignment from the Properties menu: S Left makes the entry left-aligned in the cell (CODE + L). S Center centers the entry in the cell (CODE + E). S Right makes the entry right-aligned in the cell (CODE + R). S General makes labels left-aligned and values right-aligned (CODE + J). Spreadsheet 162

  • 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
162
4. Click on Apply to apply your changes.
The dialog box remains on the
screen until you close it, so that you can keep adjusting the width.
5. Click on Close to close the dialog box.
"
To set a row height manually:
1. Select the row for which you want to set the height. You can either click
the row header or select a cell in the row.
2. Choose Row Height from the Cell menu.
The dialog box at the left
appears.
3. Click on the Automatic check box to turn off, and click inside the Height
value selector.
4. Enter the number of points you want to use for the row height.
5. Click on Apply to apply your changes.
The dialog box remains on the screen until you close it, so that you
can keep adjusting the height.
6. Click on Close to close the dialog box when you are done adjusting the
row height.
Changing Alignment
Usually, you want labels to line up at the left edge of a cell, and you want
values to line up at the right edge. In other words, you want labels to be
left-aligned
, and you want values
right-aligned
. When you enter
something in a cell, Spreadsheet automatically aligns it in this way.
If you enter a formula, the result of the formula appears right-aligned.
"
To change the alignment of cells:
1. Select the cells you want to align.
2. Choose Alignment from the Properties menu:
S
Left makes the entry left-aligned in the cell (
CODE + L
).
S
Center centers the entry in the cell (
CODE + E
).
S
Right makes the entry right-aligned in the cell (
CODE + R
).
S
General makes labels left-aligned and values right-aligned
(
CODE + J
).
Normally
the height of each row
adjusts automatically to
accommodate the text size you
use. However
, you can manually
change the row height if you want
to use a different setting.
Y
ou can change justification by
clicking a button on the Advanced
Functions tool bar
.