Apple M9057 User Manual - Page 165

Adding borders, colors, and patterns to cells, Locking row and column titles, Show Tools

Page 165 highlights

Spreadsheet 7-19 Adding borders, colors, and patterns to cells In the Help index,* see: E borders, spreadsheet cells E spreadsheets, formatting E styles You can add borders, colors, and patterns to one or more cells, or to entire rows or columns. To add a border, color, or pattern, start by selecting the cells, rows, or columns you want to change. (If you need to use the tool panel, choose Show Tools from the Window menu.) To Do this Add a border Choose Borders from the Format menu, select border options, and then click OK. Or click one of the border buttons on the Default button bar. Choose a color from the pen color palette on the tool panel. Remove a border Choose Borders from the Format menu, deselect border options, and then click OK. Or click the border button again. Change a cell's border Select a bordered cell and then choose a color from the pen color color palette on the tool panel. Fill cells with color or pattern Click a cell and choose from the fill color and pattern palettes on the tool panel. Textures and gradients cannot be added to cells. Tip AppleWorks comes with preset table styles that you can use to change a cell's appearance and formatting in one step. To apply a style or create your own, see "Using styles" on page 9-5. Locking row and column titles In the Help index,* see: E locking To lock row and column titles in a spreadsheet document so they won't move as you scroll the rest of the spreadsheet, select the rows or columns and choose Lock Title Position from the Options menu. Choose it again when you want to unlock titles. This cell was selected when Lock Title Position was chosen Cells in the locked area have solid borders Note You can't select cells in locked titles, and you can't lock titles in a spreadsheet frame. * 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-19
Adding borders, colors, and patterns to cells
You can add borders, colors, and patterns to one or more cells, or to entire
rows or columns.
To add a border, color, or pattern, start by selecting the cells, rows, or
columns you want to change. (If you need to use the tool panel, choose
Show Tools
from the Window menu.)
Tip
AppleWorks comes with preset table styles that you can use to change a
cell’s appearance and formatting in one step. To apply a style or create your
own, see “Using styles” on page 9-5.
Locking row and column titles
To lock row and column titles in a spreadsheet document so they won’t
move as you scroll the rest of the spreadsheet, select the rows or columns
and choose
Lock Title Position
from the Options menu. Choose it again when
you want to unlock titles.
Note
You can’t select cells in locked titles, and you can’t lock titles in a
spreadsheet frame.
*
Choose Index from the
or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
To
Do this
Add a border
Choose
Borders
from the Format menu, select border options, and
then click
OK
. Or click one of the border buttons on the Default
button bar. Choose a color from the pen color palette on the tool
panel.
Remove a border
Choose
Borders
from the Format menu, deselect border options, and
then click
OK
. Or click the border button again.
Change a cell’s border
color
Select a bordered cell and then choose a color from the pen color
palette on the tool panel.
Fill cells with color
or pattern
Click a cell and choose from the fill color and pattern palettes on
the tool panel. Textures and gradients cannot be added to cells.
In the Help index,
*
see:
E
borders, spreadsheet cells
E
spreadsheets, formatting
E
styles
In the Help index,
*
see:
E
locking
Cells in the locked area
have solid borders
This cell was selected when
Lock Title Position was chosen