Filter
Top Products
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, like documents and MS Word.
To view a table in a file, scroll to the file so that a dotted line appears around it, and press the joystick.
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
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.
• Hide headers — Hide header field and release more space for the worksheet grid.
• Hide gridlines — Hide gridlines.
Tip: To switch between the full and normal screen views, press *. To zoom in, press 5; to zoom out, press 0.
O f f i c e a p p l i c a t i o n s
Copyright © 2006 Nokia. All Rights Reserved. 60