Palm 700wx User Guide - Page 176

Creating a workbook, supported types: Column, Bar, Line, Pie

Page 176 highlights

8 YOUR MICROSOFT OFFICE TOOLS CHAPTER Worksheet names: Names that refer to other workbooks, arrays, array formulas, or intersection ranges are removed from the name list, causing those formulas to be resolved as "#NAME?" All hidden names are visible. AutoFilter Settings: AutoFilters that cause rows to be hidden are supported. Use the Unhide command to display hidden rows. Other AutoFilters are removed, but you can use the AutoFilter command in Excel Mobile to perform similar functions. Chart Formatting: All charts are saved as they appear in Excel Mobile. Unsupported chart types are changed to one of these supported types: Column, Bar, Line, Pie, Scatter, and Area. Background colors, gridlines, data labels, trend lines, shadows, 3D effects, secondary axes, and logarithmic scales are turned off. The following features are not supported in Excel Mobile and are removed or modified when you open a workbook on your smartphone: • Hidden, dialog, and macro sheets • VBA modules • Text boxes • Drawing objects and pictures • Lists • Conditional formats and controls • Pivot table data (converted to values) Creating a workbook 1 Press Start and select Programs. 2 Select Excel Mobile . 3 Press New (left action key). 4 Highlight a cell where you want to enter text or other info. 5 Enter the info in the cell, and then press Enter . TIP To insert a symbol, place the insertion point where you want the symbol. Press Menu and select Insert > Symbol. Highlight the symbol you want to insert, and then select Insert. 6 Repeat steps 4 and 5 to enter the remaining info. 7 Press OK to save the file. 168 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

YOUR MICROSOFT OFFICE TOOLS
EXCEL MOBILE
168
8
CHAPTER
Worksheet names:
Names that refer to
other workbooks, arrays, array formulas, or
intersection ranges are removed from the
name list, causing those formulas to be
resolved as “#NAME?” All hidden names
are visible.
AutoFilter Settings:
AutoFilters that cause
rows to be hidden are supported. Use the
Unhide command to display hidden rows.
Other AutoFilters are removed, but you can
use the AutoFilter command in Excel
Mobile to perform similar functions.
Chart Formatting:
All charts are saved as
they appear in Excel Mobile. Unsupported
chart types are changed to one of these
supported types: Column, Bar, Line, Pie,
Scatter, and Area. Background colors,
gridlines, data labels, trend lines, shadows,
3D effects, secondary axes, and
logarithmic scales are turned off.
The following features are not supported in
Excel Mobile and are removed or modified
when you open a workbook on your
smartphone:
Hidden, dialog, and macro sheets
VBA modules
Text boxes
Drawing objects and pictures
Lists
Conditional formats and controls
Pivot table data (converted to values)
Creating a workbook
1
Press
Start
and select
Programs
.
2
Select
Excel Mobile
.
3
Press
New
(left action key).
4
Highlight a cell where you want to enter
text or other info.
5
Enter the info in the cell, and then press
Enter
.
6
Repeat steps 4 and 5 to enter the
remaining info.
7
Press
OK
to save the file.
TIP
To insert a symbol, place the insertion
point where you want the symbol. Press
Menu
and select
Insert
>
Symbol
. Highlight
the symbol you want to insert, and then select
Insert
.