Apple M9057 User Manual - Page 157

Sorting cell data, Show Stylesheet, 3D Table 1

Page 157 highlights

In the Help index,* see: E styles Spreadsheet 7-11 Tip AppleWorks comes with preset table styles that you can use to change a cell's formatting and appearance in one step. For example, you can apply a style to format the data, highlight the titles, and apply colors to the rows. Start by creating a small spreadsheet and entering some data. Then click on the Default button bar (or choose Show Stylesheet from the Window menu) to display the stylesheet. Select rows and columns that you want to highlight and click 3D Table 1. AppleWorks applies the 3D Table 1 style to the selected cells. For information on applying styles or creating your own, see "Using styles" on page 9-5. Select the cells to format Before Then click to apply a style After To see a style's properties, click Edit, Properties of the style and then select the style 3D Table 1 Sorting cell data In the Help index,* see: E sorting spreadsheet data Sort data in numeric or alphabetical order to organize it. You can specify a major order key (the cell where the sort starts) and two minor order keys. If you are sorting a list containing duplicate entries, use second and third order keys to further organize your data, for example, by first name and middle initial. To sort spreadsheet data, select the cells you want to sort and click to sort in ascending order or click to sort in descending order. You can also choose Sort from the Calculate menu. In the Sort dialog box, select the options you want and click OK. * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.

  • 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

Spreadsheet
7-11
Tip
AppleWorks comes with preset table styles that you can use to change a
cell’s formatting and appearance in one step. For example, you can apply a
style to format the data, highlight the titles, and apply colors to the rows.
Start by creating a small spreadsheet and entering some data. Then click
on the Default button bar (or choose
Show Stylesheet
from the Window
menu)
to display the stylesheet. Select rows and columns that you want to highlight
and click
3D Table 1
. AppleWorks applies the 3D Table 1 style to the selected
cells. For information on applying styles or creating your own, see “Using
styles” on page 9-5.
Sorting cell data
Sort data in numeric or alphabetical order to organize it. You can specify a major
order key
(the cell where the sort starts) and two minor order keys. If you are
sorting a list containing duplicate entries, use second and third order keys to
further organize your data, for example, by first name and middle initial.
To sort spreadsheet data, select the cells you want to sort and click
to sort
in ascending order or click
to sort in descending order. You can also
choose
Sort
from the Calculate menu. In the Sort dialog box, select the
options you want and click
OK
.
*
Choose Index from the
or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
In the Help index,
*
see:
E
styles
Then click to
apply a style
Properties of the style
3D Table 1
Select the cells
to format
To see a style’s properties, click Edit,
and then select the style
Before
After
In the Help index,
*
see:
E
sorting spreadsheet data