Asus P835 User Manual - Page 178

Excel® Mobile, Clear, Contents, Format, Modify Sheets, Insert, Tools, Ascending

Page 178 highlights

Excel® Mobile Excel® Mobile enables you to create, view, and edit spreadsheets on your device. Any editing or formatting done on a spreadsheet file is kept intact even when you open the spreadsheet file on your computer. Excel® Mobile is compatible with Microsoft® Office Excel 2007. To launch Excel® Mobile, tap > Office Mobile > Excel Mobile. TO DO THIS Create a new spreadsheet Tap New to create a new spreadsheet; or tap Menu > File > New to create another new spreadsheet while working on a current file. A blank workbook is displayed. Enter the data for your new spreadsheet. Tap when done. Clear contents, formatting, or both Using the stylus, highlight the cells, rows, or columns that you want to clear. Tap Menu > Edit > Clear. Tap Contents to clear the contents in the highlighted cell or cells; tap Format to clear the formats applied to the cells, rows, or columns; and tap All to clear both the contents and formats applied to the cells, rows, or columns. Format cells, rows, Tap Menu > Format. Make the necessary formats for the cells, rows, or or columns columns. Modify the sheets Tap Menu > Format > Modify Sheets. You may rename, insert, delete, move up or move down the sheet. Insert cells (rows or columns), chart, symbol, function Tap Menu > Insert. Select the item that you want to insert. You may insert rows, columns, charts, symbols, or functions. Sort data Tap Menu > Tools > Sort.... Select the columns that you want to sort. Deselect the Ascending check box if you want to sort the data in descending order. Save a file 178 Tap Menu > File > Save As... Enter the name, folder, type, and location for the file. Tap Save.

  • 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

178
Excel
®
Mobile
Excel
®
Mobile enables you to create, view, and edit spreadsheets on your device. Any editing or
formatting done on a spreadsheet file is kept intact even when you open the spreadsheet file on your
computer. Excel
®
Mobile is compatible with Microsoft
®
Office Excel 2007.
To launch Excel
®
Mobile, tap
>
Office Mobile
>
Excel Mobile
.
TO
DO THIS
Create a new
spreadsheet
Tap
New
to create a new spreadsheet; or tap
Menu
>
File
>
New
to create
another new spreadsheet while working on a current file. A blank workbook is
displayed. Enter the data for your new spreadsheet. Tap
when done.
Clear contents,
formatting, or both
Using the stylus, highlight the cells, rows, or columns that you want to
clear. Tap
Menu
>
Edit
>
Clear
. Tap
Contents
to clear the contents in the
highlighted cell or cells; tap
Format
to clear the formats applied to the cells,
rows, or columns; and tap
All
to clear both the contents and formats applied
to the cells, rows, or columns.
Format cells, rows,
or columns
Tap
Menu
>
Format
. Make the necessary formats for the cells, rows, or
columns.
Modify the sheets
Tap
Menu
>
Format
>
Modify Sheets
. You may rename, insert, delete, move
up or move down the sheet.
Insert cells (rows
or columns), chart,
symbol, function
Tap
Menu
>
Insert
. Select the item that you want to insert. You may insert
rows, columns, charts, symbols, or functions.
Sort data
Tap
Menu
>
Tools
>
Sort...
. Select the columns that you want to sort.
Deselect the
Ascending
check box if you want to sort the data in descending
order.
Save a file
Tap
Menu
>
File
>
Save As...
Enter the name, folder, type, and location for
the file. Tap
Save
.