Palm 500V User Guide - Page 210

Deleting cells, rows, or columns, Deletes the entire rows

Page 210 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 3 Press Menu (right softkey) and select Edit Mode. 4 Select the area you want to move (see Selecting cells, rows, or columns). 5 Press Menu (right softkey) and select Edit > Cut or Edit > Copy. 6 Navigate to the area where you want to insert the cells, rows, or columns. 7 Press Menu (right softkey) and select Edit > Paste, Deleting cells, rows, or columns 1 Open the workbook containing the elements you want to delete. 2 If the softkey text labels are hidden, press the right or left softkey to display the labels. 3 Press Menu (right softkey) and select Edit Mode. 4 Select the area you want to delete (see Selecting cells, rows, or columns). 5 Press Menu (right softkey), select Edit > Delete Cells, and then select how you want to remove the elements: Shift cells left: Deletes the highlighted cells and moves all cells on their right to the left. Shift cells up: Deletes the highlighted cells and moves all cells below them up. Entire row: Deletes the entire row(s) in which the highlighted cells are located, and moves all rows below them up. Entire column: Deletes the entire column(s) in which the highlighted cells are located, and moves all columns on their right to the left. NOTE Excel Mobile adjusts formulas to reflect the new cell locations. However, a formula that refers to a deleted cell displays the #REF! error value. 6 Press Done (left softkey). 210 E X C E L M O B I L E

  • 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
210
11
CHAPTER
3
Press
Menu
(right softkey) and
select
Edit Mode
.
4
Select the area you want to move (see
Selecting cells, rows, or columns
).
5
Press
Menu
(right softkey) and
select
Edit
>
Cut
or
Edit
>
Copy
.
6
Navigate to the area where you want to
insert the cells, rows, or columns.
7
Press
Menu
(right softkey) and
select
Edit
>
Paste
,
Deleting cells, rows, or columns
1
Open the workbook containing the
elements you want to delete.
2
If the softkey text labels are hidden,
press the
right
or
left
softkey to display the labels.
3
Press
Menu
(right softkey) and
select
Edit Mode
.
4
Select the area you want to delete (see
Selecting cells, rows, or columns
).
5
Press
Menu
(right softkey), select
Edit
>
Delete Cells
, and then select
how you want to remove the elements:
Shift cells left:
Deletes the highlighted
cells and moves all cells on their right to
the left.
Shift cells up:
Deletes the highlighted
cells and moves all cells below them up.
Entire row:
Deletes the entire row(s) in
which the highlighted cells are located,
and moves all rows below them up.
Entire column:
Deletes the entire
column(s) in which the highlighted cells
are located, and moves all columns on
their right to the left.
NOTE
Excel Mobile adjusts formulas to
reflect the new cell locations. However, a
formula that refers to a deleted cell
displays the #REF! error value.
6
Press
Done
(left softkey).