Nokia 9500 Communicator

Page 46
background image
9.
Sheet
In 
Sheet
 you can store your data in a file that is called a workbook. Each workbook contains at least one worksheet. A workbook
can also contain charts; a chart sheet is a sheet containing a chart that is based on data from a worksheet.
Go to 
Desk
 > 
Office
 > 
Sheet
.
Workbooks
To create a new workbook, press Menu, and select 
File
 > 
New workbook
.
To open an existing workbook, press Menu, and select 
File
 > 
Open
. Browse for the folder where the file is saved.
Tip: To open recently used workbooks, press Menu, and select 
File
 > 
Recent workbooks
.
Working with worksheets
To insert data into cells, move to the cell with the scroll key, and enter the information.
To select an entire row in a worksheet, move the cursor to the first cell on that row, and press Shift+scroll key left. To select an
entire column, move the cursor to the first cell of the column, and press Shift+scroll key up.
To format worksheets, select the cell or cells you want to format, press Menu, and select 
Format
 and an appropriate menu option.
You can change the font and number formats, and adjust alignment, row height, and column width. To format borders or the
background color of a cell, select 
Format
 > 
Cell appearance
 > 
Borders
 or 
Background colour
.
To add a new worksheet into a workbook, press Menu, and select 
Insert
 > 
New worksheet
.
To switch to another worksheet, press Menu, and select 
View
 > 
Worksheets
, or 
Sheets/Charts
 if the workbook contains at least
one chart. Select the worksheet, and press 
OK
.
To keep rows visible when scrolling, select the row below the area that you want to remain visible. To keep columns visible,
select the column to the right of the area that you want to remain visible. Press Menu, and select 
View
 > 
Freeze panes
.
To search for data, press Menu, and select 
Edit
 > 
Find
. Enter the text or numbers you want to find, and press 
Find
. To search the
worksheet according to certain criteria, press 
Options
.
To rename a worksheet, press Menu, and select 
Format
 > 
Rename worksheet
. Enter the new name, and press 
Done
.
Working with cells
To clear contents or formatting from cells, select the cells, and press 
Clear
. If you select 
Formats
, the formatting of the selected
cells is removed, but the content remains. The default style is used. If you select 
Contents
, the content of the selected cells is
deleted, but the formatting stays the same. 
All
 clears both formatting and contents of the selected cells.
To insert cells, select the area where you want to insert new cells, press Menu, and select 
Insert
 > 
Cells
. You can insert cells
above (
Shift cells down
) or to the left (
Shift cells right
) of the selected range. If you have selected only one cell, only one new
cell is inserted, and if you have selected a range of cells, a corresponding range of blank cells is inserted. To insert a new row or
column, select 
Entire row
 or 
Entire column
, and press 
OK
.
To select a range of cells, press Menu, and select 
Edit
 > 
Select
. To select the entire worksheet, select 
Entire worksheet
 in the
Range
 field.
Tip:  To select column A, select 
Reference
, move to the 
Reference
 field and type A:A. Similarly, to select columns from
A to C, type A:C. To select row 1, type 1:1. To select columns from A to C and rows 2 and 3, type A2:C3.
To select the cells you have named on the worksheet, press Menu, and select 
Edit
 > 
Select
. Select 
Named cells
 in the 
Range
 field,
and select the cell in the 
Named area
 field. Once you have selected the cell, press 
Done
.
To rearrange the order of cells, select the cells, press Menu, and select 
Tools
 > 
Sort
 > 
Top to bottom
 or 
Left to right
. On the 
1st
column
 or 
1st row
 page, select the direction of sorting, and to sort by case, select 
Yes
 in the 
Case sensitive
 field. If you have
selected more than one row or column, move to the second and third page to sort the next column or row.
To insert a function into a selected cell, press 
Insert function
 in the worksheet. Functions are used to automate calculations. You
can choose from different function categories, and each category has a set of functions. For example, MIN finds the lowest value
in the numeric contents of a selected range of cells, AVERAGE calculates the average of the values, and SUM adds the values
together. Once you have selected a function, press 
Done
. The function is inserted into the selected worksheet cell. On the
worksheet, press 
Point reference
, select the cells you want to include in the function with Shift+scroll key, and press 
OK
.
Copyright © 2004-2005 Nokia. All Rights Reserved.
46
Page 1 Page 2 Page 3 Page 4 Page 5 Page 6 Page 7 Page 8 Page 9 Page 10 Page 11 Page 12 Page 13 Page 14 Page 15 Page 16 Page 17 Page 18 Page 19 Page 20 Page 21 Page 22 Page 23 Page 24 Page 25 Page 26 Page 27 Page 28 Page 29 Page 30 Page 31 Page 32 Page 33 Page 34 Page 35 Page 36 Page 37 Page 38 Page 39 Page 40 Page 41 Page 42 Page 43 Page 44 Page 45 Page 46 Page 47 Page 48 Page 49 Page 50 Page 51 Page 52 Page 53 Page 54 Page 55 Page 56 Page 57 Page 58 Page 59 Page 60 Page 61 Page 62 Page 63 Page 64 Page 65 Page 66 Page 67 Page 68 Page 69 Page 70 Page 71 Page 72 Page 73 Page 74 Page 75 Page 76 Page 77 Page 78 Page 79 Page 80 Page 81 Page 82 Page 83 Page 84 Page 85 Page 86 Page 87 Page 88 Page 89 Page 90 Page 91 Page 92 Page 93 Page 94 Page 95 Page 96 Page 97 Page 98 Page 99 Page 100 Page 101 Page 102 Page 103 Page 104 Page 105 Page 106 Page 107 Page 108