Palm 700wx User Guide - Page 179

Entering a sequence automatically, Adding cells, rows, and columns

Page 179 highlights

YOUR MICROSOFT OFFICE TOOLS 8 CHAPTER 5 Select OK. Entering a sequence automatically 1 Highlight both the cells containing the info you want to automate and the adjacent destination cells. 6 Select OK. TIP Select Autofill as the series type when you want to quickly fill cells with repetitive data such as numbers or repeated text. Autofill takes the content of the first cell in the highlighted row or column and copies it down or across the rest of the selection. 2 Press Menu (right action key) and select Edit > Fill. 3 Select the Direction list, and then select the direction you want to populate. 4 Select the Fill type list, and then select Series. 5 Select the Series type list, and then select the type of series you want. If you select Date or Number, enter a Step value increment. Adding cells, rows, and columns 1 Open the workbook you want to add to. 2 Highlight the area where you want to insert elements. 3 Press Menu (right action key) and select Insert > Cells. 4 Select how you want to insert the elements: Shift cells right: Inserts a new cell. The highlighted cell and all cells on its right move one column to the right. Shift cells down: Inserts a new cell. The highlighted cell and all cells below it move down one row. Entire row: Inserts a new row. The entire row in which the highlighted cell is located and all rows below it move down one row. E X C E L M O B I L E 171

  • 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

YOUR MICROSOFT OFFICE TOOLS
EXCEL MOBILE
171
8
CHAPTER
5
Select
OK
.
Entering a sequence automatically
1
Highlight both the cells containing the
info you want to automate and the
adjacent destination cells.
2
Press
Menu
(right action key) and
select
Edit
>
Fill
.
3
Select the
Direction
list, and then
select the direction you want to
populate.
4
Select the
Fill type
list, and then
select
Series
.
5
Select the
Series type
list, and then
select the type of series you want. If
you select Date or Number, enter a Step
value increment.
6
Select
OK
.
Adding cells, rows, and columns
1
Open the workbook you want to add to.
2
Highlight the area where you want to
insert elements.
3
Press
Menu
(right action key) and
select
Insert
>
Cells
.
4
Select how you want to insert the
elements:
Shift cells right:
Inserts a new cell. The
highlighted cell and all cells on its right
move one column to the right.
Shift cells down:
Inserts a new cell.
The highlighted cell and all cells below it
move down one row.
Entire row:
Inserts a new row. The
entire row in which the highlighted cell
is located and all rows below it move
down one row.
TIP
Select Autofill as the series type when you
want to quickly fill cells with repetitive data
such as numbers or repeated text. Autofill
takes the content of the first cell in the
highlighted row or column and copies it down
or across the rest of the selection.