Nokia E62 User Guide - Page 56

Table editor, Sheet, Outline view, Work with worksheets

Page 56 highlights

Office applications Replace to replace the text and move to the next match, or select Ignore to skip the current match and Next to move to the next match. Tip: To skip the current match and move to the previous and next ones, scroll up and down with the joystick. Table editor You can view tables created in applications such as MS Word. To view a table in a file, scroll to the table. When a dotted line appears around the table, press the joystick to open it. To change the selected cell, scroll up, down, left or right. If the selected cell does not fit into visible area, pressing the joystick pans the whole content first before the cell changes. To edit the text in a cell, select the cell, and press the joystick. To end editing, press the joystick again. Select Options and from the following options: • Zoom - Zoom the table view in, out and to edit a zoom ratio. • Format - Modify the font style and formatting, paragraphs, bullets, and borders. • Cell size - Change the size of the cells, rows and columns. • Cells - Select option to insert, delete, merge or separate cells. • Copy table - Copy the text of the whole table to the clipboard. Sheet This device supports common features of Microsoft Word, PowerPoint, and Excel (Microsoft Office 97, 2000, XP, and 2003). Not all file formats can be viewed or modified. Select Menu > Office > Sheet. You can store data in a file that is called a workbook. Each workbook contains at least one worksheet. A workbook can also contain charts, which are based on data from a worksheet. To open an existing workbook, browse for the folder where the file is saved, and press the joystick. To create a new workbook, select Options > New file. Select Blank to create a new file without using any template or Use template to create a file based on an existing template. Select the worksheet in the outline view, and press the joystick to open the file. Tip: To open a recently used workbook, select Options > Most recent files. Outline view Outline view enables you to open and navigate worksheets, charts, and named cells. In outline view, each worksheet has its own main level icon. Under the main level there are sub-items for charts and named cells. To open the outline view, scroll to the folder and file, and press the joystick. The outline view opens. Recently used worksheet opens the latest view and settings. To show and hide charts and cells, scroll to the worksheet, press the joystick, and select Options > Collapse or Expand. To delete or rename worksheets, charts, or named cells, scroll to the item, and select Options > Worksheet, Chart, or Named cell, and the appropriate option. To create a new worksheet, chart, or named cell, scroll to the position you want to add the new item, and select Options > Insert > Worksheet, Chart, or Named cell. Work with worksheets To insert data into cells, open the worksheet view. Use the joystick to move to the cell, and select Options > Show cell field > Edit cell field. An upper part editing field opens. Enter the data, and select Done to finish editing. To select a range of cells, press and hold the shift key while you scroll right. To select rows, move the cursor to the first cell on a row, and press and hold the shift key while you scroll left. To select columns, move the cursor to the first cell on a column, and press and hold the shift key while you scroll up. To select the entire worksheet, move the cursor to cell A1, and press and hold the shift key while you scroll up and left. To modify the worksheet view, select Options > View. Select from the following options: • Pan worksheet - Define the size of the visible area of the whole worksheet. • Full screen - Switch to the full screen view. Copyright © 2006 Nokia. All Rights Reserved. 56

  • 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

Replace
to replace the text and move to the next match, or select
Ignore
to skip the current match and
Next
to move to the next
match.
Tip:
To skip the current match and move to the previous and next ones, scroll up and down with the joystick.
Table editor
You can view tables created in applications such as MS Word.
To view a table in a file, scroll to the table. When a dotted line appears around the table, press the joystick to open it.
To change the selected cell, scroll up, down, left or right. If the selected cell does not fit into visible area, pressing the joystick
pans the whole content first before the cell changes.
To edit the text in a cell, select the cell, and press the joystick. To end editing, press the joystick again.
Select
Options
and from the following options:
Zoom
— Zoom the table view in, out and to edit a zoom ratio.
Format
— Modify the font style and formatting, paragraphs, bullets, and borders.
Cell size
— Change the size of the cells, rows and columns.
Cells
— Select option to insert, delete, merge or separate cells.
Copy table
— Copy the text of the whole table to the clipboard.
Sheet
This device supports common features of Microsoft Word, PowerPoint, and Excel (Microsoft Office 97, 2000, XP, and 2003). Not
all file formats can be viewed or modified.
Select
Menu
>
Office
>
Sheet
.
You can store data in a file that is called a workbook. Each workbook contains at least one worksheet. A workbook can also
contain charts, which are based on data from a worksheet.
To open an existing workbook, browse for the folder where the file is saved, and press the joystick.
To create a new workbook, select
Options
>
New file
. Select
Blank
to create a new file without using any template or
Use
template
to create a file based on an existing template. Select the worksheet in the outline view, and press the joystick to open
the file.
Tip:
To open a recently used workbook, select
Options
>
Most recent files
.
Outline view
Outline view enables you to open and navigate worksheets, charts, and named cells.
In outline view, each worksheet has its own main level icon. Under the main level there are sub-items for charts and named
cells.
To open the outline view, scroll to the folder and file, and press the joystick. The outline view opens. Recently used worksheet
opens the latest view and settings.
To show and hide charts and cells, scroll to the worksheet, press the joystick, and select
Options
>
Collapse
or
Expand
.
To delete or rename worksheets, charts, or named cells, scroll to the item, and select
Options
>
Worksheet
,
Chart
, or
Named
cell
, and the appropriate option.
To create a new worksheet, chart, or named cell, scroll to the position you want to add the new item, and select
Options
>
Insert
>
Worksheet
,
Chart
, or
Named cell
.
Work with worksheets
To insert data into cells, open the worksheet view. Use the joystick to move to the cell, and select
Options
>
Show cell field
>
Edit cell field
. An upper part editing field opens. Enter the data, and select
Done
to finish editing.
To select a range of cells, press and hold the shift key while you scroll right.
To select rows, move the cursor to the first cell on a row, and press and hold the shift key while you scroll left. To select columns,
move the cursor to the first cell on a column, and press and hold the shift key while you scroll up.
To select the entire worksheet, move the cursor to cell A1, and press and hold the shift key while you scroll up and left.
To modify the worksheet view, select
Options
>
View
.
Select from the following options:
Pan worksheet
— Define the size of the visible area of the whole worksheet.
Full screen
— Switch to the full screen view.
Office applications
Copyright © 2006 Nokia. All Rights Reserved.
56