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.
O f f i c e a p p l i c a t i o n s
Copyright © 2006 Nokia. All Rights Reserved.
54
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.
To add a comment to the selected cell, select
Options
>
Advanced options
>
Insert comment
. Write a comment, and select
OK
.
The cell is marked with a small triangle in the upper right corner of the cell.
To change the font and number formatting, borders, and alignments, select
Options
>
Format
and the appropriate option.
To keep rows visible when scrolling, select a cell below the area that you want to remain visible and
Options
>
Advanced
options
>
Freeze panes
. To keep columns visible, select a cell to the right of the area that you want to remain visible and
Options
>
Advanced options
>
Freeze panes
.
To change the size of rows and columns, select
Options
>
Cell size
>
Row height
or
Column width
.
To sort rows from left to right, select the cells you want to sort and
Options
>
Advanced options
>
Sort rows
. You can select the
number of the row to use as a primary sorting criteria. You can change the direction of the sorting order and ignore or match
the case sensitivity.
To sort columns from top to bottom, select the cells you want to sort and
Options
>
Advanced options
>
Sort columns
. You can
select the column to use as a primary sorting criteria. You can change the direction of the sorting order and ignore or match
the case sensitivity.
To format a font style, select the cells whose font style you want to modify and
Options
>
Format
>
Font
. You can change the
font type, size, text color, and background color of the cell.
To change a font formatting, select the cells you want to format and
Options
>
Format
>
Font formatting
. You can bold, italicize,
underline, strikethrough, or position the text in superscript or subscript format within a cell.
To align cell contents, select the cells whose alignment you want to modify and
Options
>
Format
>
Alignment
. You can change
both the horizontal and vertical alignment and wrap text to adjust the row height of the selected cells to display the entire
content of a cell.
To format cell borders, select the cells whose borders you want to modify and
Options
>
Format
>
Borders
. You can modify all
or only vertical, horizontal, upper, lower, left or right borders. Select
Options
>
Change
to edit the style and color of the borders.
To change the number format, select the cells whose number format you want to modify and
Options
>
Format
>
Numbers
.
Select the number format from the list. If the format you select includes decimal values, enter a number from 0 to 12 to indicate
the decimal place.
Example: If you want to compare and calculate different loan rates, you can set the number format to
Percentage
.