Apple M9057 User Manual - Page 163

Changing cells, rows, and columns, Resizing or hiding rows and columns

Page 163 highlights

Spreadsheet 7-17 Changing cells, rows, and columns There are several features that control how you display and work with data in rows and columns. You can resize, hide, insert, and delete rows and columns. Resizing or hiding rows and columns In the Help index,* see: E hiding E resizing, spreadsheet cells To resize all the rows or columns in a range by the same amount, start by selecting multiple rows or columns. Then specify a size or use the mouse. To resize rows or columns by specifying a size, select the rows or columns to change. Then choose Row Height or Column Width from the Format menu, type a new measurement (type 0 to hide the row or column, or select Use default to revert to the default row or column size), and then click OK. Resize pointer To resize or hide rows or columns by using the mouse, move the pointer to the bottom of the row heading or to the right edge of the column heading to change. The pointer becomes a double arrow . To Resize a row or column Hide a row or column Restore a hidden row or column Resize rows and columns to the smallest size that holds the data Do this Drag the pointer until the row or column is the desired size. Drag the pointer up or to the left until the row or column disappears. Drag the pointer down or to the right until the row or column reappears. Double-click the divider at the bottom of the row heading or at the right edge of the column heading. (You see the double arrow when you're in the right place.) * 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-17
Changing cells, rows, and columns
There are several features that control how you display and work with data
in rows and columns. You can resize, hide, insert, and delete rows and
columns.
Resizing or hiding rows and columns
To resize all the rows or columns in a range by the same amount, start by
selecting multiple rows or columns. Then specify a size or use the mouse.
To resize rows or columns by specifying a size, select the rows or columns
to change. Then choose
Row Height
or
Column Width
from the Format menu, type
a new measurement (type
0
to hide the row or column, or select
Use default
to
revert to the default row or column size), and then click
OK
.
To resize or hide rows or columns by using the mouse, move the pointer to
the bottom of the row heading or to the right edge of the column heading to
change. The pointer becomes a double arrow
.
*
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
Resize a row or column
Drag the pointer until the row or column is the
desired size.
Hide a row or column
Drag the pointer up or to the left until the row or
column disappears.
Restore a hidden row or column
Drag the pointer down or to the right until the row
or column reappears.
Resize rows and columns to the
smallest size that holds the data
Double-click the divider at the bottom of the row
heading or at the right edge of the column heading. (You
see the double arrow
when you’re in the right place.)
In the Help index,
*
see:
E
hiding
E
resizing, spreadsheet cells
Resize pointer