Palm 700wx User Guide - Page 180

Formatting cells, Formatting rows and columns, Format, Modify Sheets, Insert, Move Up, Define

Page 180 highlights

8 YOUR MICROSOFT OFFICE TOOLS CHAPTER Entire column: Inserts a new column. The entire column in which the highlighted cell is located and all columns to its right move one column to the right. 5 Select OK. Formatting cells 1 Open the workbook you want to format. 2 Highlight the cells you want to format. 3 Press Menu (right action key) and select Format > Cells. 4 Select any of the following: Size: Sets the row height and column width. Number: Sets the type of information the cells contain. Align: Sets whether text wraps within the highlighted cells, and sets horizontal and vertical alignment position. Font: Sets the typeface, color, size, and style attributes. Borders: Turns borders on and off for various cell edges, and sets the border and background colors. 5 Press OK . TIP To add a new worksheet, press Menu and select Format > Modify Sheets. Select Insert, enter a name for the worksheet, and then press OK. To change the order of the worksheets, highlight a worksheet you want to move, and then select Move Up or Move Down. Press OK to finish. TIP To name the highlighted cell or range of cells, press Menu and select Insert > Define Name. Enter the name and select Add. Press OK. Formatting rows and columns 1 Open the workbook you want to format. 2 Highlight the rows or columns you want to format. 3 Press Menu (right action key), and then select Format > Row or Format> Column. 4 Select any of the following: AutoFit: Adjusts the size of the highlighted rows or columns to their contents. Hide: Hides the highlighted rows or columns. 172 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
172
8
CHAPTER
Entire column:
Inserts a new column.
The entire column in which the
highlighted cell is located and all
columns to its right move one column
to the right.
5
Select
OK
.
Formatting cells
1
Open the workbook you want to format.
2
Highlight the cells you want to format.
3
Press
Menu
(right action key) and
select
Format
>
Cells
.
4
Select any of the following:
Size:
Sets the row height and column
width.
Number:
Sets the type of information
the cells contain.
Align:
Sets whether text wraps within
the highlighted cells, and sets horizontal
and vertical alignment position.
Font:
Sets the typeface, color, size, and
style attributes.
Borders:
Turns borders on and off for
various cell edges, and sets the border
and background colors.
5
Press
OK
.
Formatting rows and columns
1
Open the workbook you want to format.
2
Highlight the rows or columns you want
to format.
3
Press
Menu
(right action key),
and then select
Format
>
Row
or
Format
>
Column
.
4
Select any of the following:
AutoFit:
Adjusts the size of the
highlighted rows or columns to their
contents.
Hide:
Hides the highlighted rows or
columns.
TIP
To add a new worksheet, press
Menu
and
select
Format
>
Modify Sheets
. Select
Insert
, enter a name for the worksheet, and
then press
OK
. To change the order of the
worksheets, highlight a worksheet you want
to move, and then select
Move Up
or
Move
Down
. Press
OK
to finish.
TIP
To name the highlighted cell or range of
cells, press
Menu
and select
Insert
>
Define
Name
. Enter the name and select
Add
. Press
OK
.