Palm 500V User Guide - Page 209

Moving cells, rows, or columns, containing two cells A1 and A2

Page 209 highlights

11 Y O U R M I C R O S O F T O F F I C E A N D O T H E R D O C U M E N T T O O L S CHAPTER A2), selecting Entire row inserts two rows; so the original rows 1 and 2 (and their contents) are now rows 3 and 4. The rows containing the selected area and all rows beneath it move the same number of rows-two in this example- down. Column: Inserts the same number of new columns as the number of cells you selected horizontally in step 2. For example, if you selected an area containing two cells (A1 and B1) horizontally, selecting Entire column inserts two columns; so the original columns A and B (and their contents) are now columns C and D. The columns containing the selected area and all columns to the right of it move the same number of columns-two in this example-to the right. Shift Right: Inserts the same number of new cells as the number of cells you selected horizontally in step 2. For example, if you selected an area containing two cells (A1 and B1) horizontally, selecting Shift cells right inserts two horizontal cells; so the original A1 and B1 (and their contents) are now C1 and D1. The selected area and all cells to the right of it move the same number of columns-two in this example-to the right. Shift Down: Inserts the same number of new cells as the number of cells you selected vertically in step 2. For example, if you selected an area containing two cells (A1 and A2) vertically, selecting Shift cells down inserts two vertical cells; so the original A1 and A2 (and their contents) are now A3 and A4. The selected area and all cells below it move the same number of rows-two in this example-down. 6 Press Done (left softkey). Moving cells, rows, or columns You can cut or copy an area of a worksheet and paste it elsewhere on the same worksheet or on a different worksheet. 1 Open the workbook containing the elements you want to move. 2 If the softkey text labels are hidden, press the right or left softkey to display the labels. E X C E L M O B I L E 209

  • 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

YOUR MICROSOFT OFFICE AND OTHER DOCUMENT TOOLS
EXCEL MOBILE
209
11
CHAPTER
A2), selecting Entire row inserts two
rows; so the original rows 1 and 2 (and
their contents) are now rows 3 and 4.
The rows containing the selected area
and all rows beneath it move the same
number of rows—two in this example—
down.
Column:
Inserts the same number of
new columns as the number of cells
you selected horizontally in step 2. For
example, if you selected an area
containing two cells (A1 and B1)
horizontally, selecting Entire column
inserts two columns; so the original
columns A and B (and their contents)
are now columns C and D. The columns
containing the selected area and all
columns to the right of it move the
same number of columns—two in this
example—to the right.
Shift Right:
Inserts the same number
of new cells as the number of cells you
selected horizontally in step 2. For
example, if you selected an area
containing two cells (A1 and B1)
horizontally, selecting Shift cells right
inserts two horizontal cells; so the
original A1 and B1 (and their contents)
are now C1 and D1. The selected area
and all cells to the right of it move the
same number of columns—two in this
example—to the right.
Shift Down:
Inserts the same number
of new cells as the number of cells you
selected vertically in step 2. For
example, if you selected an area
containing two cells (A1 and A2)
vertically, selecting Shift cells down
inserts two vertical cells; so the original
A1 and A2 (and their contents) are now
A3 and A4. The selected area and all
cells below it move the same number of
rows—two in this example—down.
6
Press
Done
(left softkey).
Moving cells, rows, or columns
You can cut or copy an area of a worksheet
and paste it elsewhere on the same
worksheet or on a different worksheet.
1
Open the workbook containing the
elements you want to move.
2
If the softkey text labels are hidden,
press the
right
or
left
softkey to display the labels.