Nokia 7710 User Guide - Page 93

Sheet, Workbooks, Working with worksheets

Get Nokia 7710 - Cell Phone 90 MB PDF manuals and user guides View all Nokia 7710 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 93 highlights

Sheet Sheet Go to Desk > Sheet. In the Sheet application you can work and 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 chartsheet is a sheet containing a chart that is based on data from a worksheet. The Sheet application can open documents created with Microsoft Excel 97 for Windows or later. Note that not all features and formatting of the original documents will be supported. The maximum number of characters in a single cell is 256, and cells containing more characters will have the contents truncated when the file format is converted. Workbooks To protect a workbook from editing, press in the list view and select Tools > Details. Select the Read-only: check box and tap OK. The workbook can now be viewed but not edited. To create, open or rename a workbook, press and select the approriate command in the Workbook menu. Working with worksheets To create a duplicate of a worksheet, tap Worksheets / Charts. Select the sheet and tap Duplicate. To rename a worksheet, tap Worksheets / Charts. Select the sheet and tap Rename. Write the new name and tap OK. To select a cell you have named, press and select Edit > Mark/Unmark. Select Named area for the range and choose from the list the cell you want, then tap 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. Then tap on the toolbar, or press and select Display > Freeze panes. To go to a particular cell or named area, tap Go To. Specify the cell or named area where you want to go and tap OK. Tip: You can insert a sum for a range of cells automatically by using the toolbar icon . Select the cell where you want to add the sum and tap . The suggested formula is shown in the formula field on top 93 Copyright © 2005 Nokia. All rights reserved.

  • 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
Sheet
93
Copyright © 2005 Nokia. All rights reserved.
Sheet
Go to
Desk
>
Sheet
.
In the Sheet application you can work and 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 chartsheet is a sheet containing a chart that is
based on data from a worksheet.
The Sheet application can open documents created with
Microsoft Excel 97 for Windows or later. Note that not all
features and formatting of the original documents will be
supported. The maximum number of characters in a single
cell is 256, and cells containing more characters will have
the contents truncated when the file format is converted.
Workbooks
To protect a workbook from editing
, press
in the
list view and select
Tools
>
Details
. Select the
Read-only:
check box and tap
OK
. The workbook can now be
viewed but not edited.
To create, open or rename a workbook
, press
and
select the approriate command in the
Workbook
menu.
Working with worksheets
To create a duplicate of a worksheet
, tap
Worksheets / Charts
. Select the sheet and tap
Duplicate
.
To rename a worksheet
, tap
Worksheets / Charts
.
Select the sheet and tap
Rename
. Write the new name
and tap
OK
.
To select a cell you have named
, press
and select
Edit
>
Mark/Unmark
. Select
Named area
for the range
and choose from the list the cell you want, then tap
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. Then tap
on the toolbar, or press
and select
Display
>
Freeze panes
.
To go to a particular cell or named area
, tap
Go To
.
Specify the cell or named area where you want to go
and tap
OK
.
Tip:
You can insert a sum for a range of cells
automatically by using the toolbar icon
. Select the
cell where you want to add the sum and tap
. The
suggested formula is shown in the formula field on top