Palm 700wx User Guide - Page 181

Renaming a worksheet, Sorting info in a worksheet

Page 181 highlights

CHAPTER YOUR MICROSOFT OFFICE TOOLS 8 Unhide: Displays hidden rows or columns in the highlighted area. DID YOU KNOW? You can adjust the column and row size by tapping and dragging the right edge of the column or the bottom edge of the row. To automatically fit rows and columns to their contents, double-tap the lower edge of the row heading or the right edge of the column heading. Renaming a worksheet 1 Open the workbook containing the worksheet you want to rename. 2 Press Menu (right action key) and select Format > Modify Sheets. 3 In the Sheets list, highlight the worksheet you want to rename. 4 Select Rename, enter a new name for the worksheet, and then press OK twice. Sorting info in a worksheet 1 Highlight the cells you want to sort. 2 Press Menu (right action key) and select Tools > Sort. 3 Select the Sort by list, and then select the primary sort column. 4 Check or uncheck the Ascending box to indicate whether you want to sort in ascending or descending order. 5 (Optional) Select the Then by lists, and then select second and third level sorting options. 6 Check or uncheck the Exclude header row from sort box to indicate whether you want to sort the header row. 7 Select OK. Filtering info in a worksheet 1 Highlight the cells that contain the info you want to filter. 2 Press Menu (right action key) and select Tools > AutoFilter. A list appears at the top of each related column. 3 Select one of the new lists, and then select a filter. This hides all rows that do not include the selected filter. 4 (Optional) Select the other lists, and then select other filters. E X C E L M O B I L E 173

  • 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
173
8
CHAPTER
Unhide:
Displays hidden rows or
columns in the highlighted area.
Renaming a worksheet
1
Open the workbook containing the
worksheet you want to rename.
2
Press
Menu
(right action key) and
select
Format
>
Modify Sheets
.
3
In the Sheets list, highlight the
worksheet you want to rename.
4
Select
Rename
, enter a new name for
the worksheet, and then press
OK
twice.
Sorting info in a worksheet
1
Highlight the cells you want to sort.
2
Press
Menu
(right action key) and
select
Tools
>
Sort
.
3
Select the
Sort by
list, and then select
the primary sort column.
4
Check or uncheck the
Ascending
box to
indicate whether you want to sort in
ascending or descending order.
5
(Optional) Select the
Then by
lists, and
then select second and third level
sorting options.
6
Check or uncheck the
Exclude header
row from sort
box to indicate whether
you want to sort the header row.
7
Select
OK
.
Filtering info in a worksheet
1
Highlight the cells that contain the info
you want to filter.
2
Press
Menu
(right action key) and
select
Tools
>
AutoFilter
. A list appears
at the top of each related column.
3
Select one of the new lists, and then
select a filter. This hides all rows that do
not include the selected filter.
4
(Optional) Select the other lists, and
then select other filters.
DID
YOU
KNOW
?
You can adjust the column and
row size by tapping and dragging the right
edge of the column or the bottom edge of the
row. To automatically fit rows and columns to
their contents, double-tap the lower edge of
the row heading or the right edge of the
column heading.