Nokia 7710 User Guide - Page 94

Formatting worksheets, Chart sheets, Preview, X-axis settings

Page 94 highlights

Sheet of the worksheet. You can change the suggested formula by editing it in the formula field, or accept it by exiting the cell. Formatting worksheets First select the cell or cells you want to format. To format fonts, press and select Format > Font. You can change the font type, size, and colour. You can also add bold, italic, underline, and strikethrough formatting. You can raise or lower the text by selecting superscript or subscript formatting. To see the effect of the changes, tap Preview. To change number format, press and select Format > Numbers. For example, you can specify how the date, time, or currency is displayed. To align cell contents, press and select Format > Alignment. If you select Wrap text to cell:, the row height of the selected cell will be adjusted to display the entire content of the cell. To adjust the row height or column width, drag the boundary below the row heading or on the right side of the column heading until the row/column is the size you want. To specify the height or width more precisely, press and select Format > Row height or Column width. Specify the height or width and tap OK. To format cell borders, press and select Format > Borders. You can add a border to any side of a cell. Choose a style and colour for the border and tap OK. To change the background colour of a cell, press and select Format > Background colour. Choose a colour and tap OK. To show or hide gridlines, zero values, and headers, press and select Tools > Settings. Select the items you want to make visible in the worksheet and tap OK. Chart sheets To format a chart in detail, press and select Format. Select the object you want to edit. The selection of settings varies depending on the type of the chart. Tip: You can access some of the setting dialogs by tapping the relevant item in the chart. For example, the X-axis settings dialog opens when you double-tap the X-axis in the chart. Font - You can change the font type, size and colour. You can also add bold, italic, underline, and strikethrough formatting. You can raise or lower the text by selecting superscript or subscript formatting. To see the effect of the changes, tap Preview. Chart - You can select the chart type, make the chart three-dimensional, and change the colour of the 94 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
94
Copyright © 2005 Nokia. All rights reserved.
of the worksheet. You can change the suggested
formula by editing it in the formula field, or accept it
by exiting the cell.
Formatting worksheets
First select the cell or cells you want to format.
To format fonts
, press
and select
Format
>
Font
.
You can change the font type, size, and colour. You can
also add bold, italic, underline, and strikethrough
formatting. You can raise or lower the text by selecting
superscript or subscript formatting. To see the effect of
the changes, tap
Preview
.
To change number format
, press
and select
Format
>
Numbers
. For example, you can specify how
the date, time, or currency is displayed.
To align cell contents
, press
and select
Format
>
Alignment
. If you select
Wrap text to cell:
, the row height
of the selected cell will be adjusted to display the
entire content of the cell.
To adjust the row height or column width
, drag the
boundary below the row heading or on the right side
of the column heading until the row/column is the size
you want.
To specify the height or width more
precisely
, press
and select
Format
>
Row height
or
Column width
. Specify the height or width and tap
OK
.
To format cell borders
, press
and select
Format
>
Borders
. You can add a border to any side of a cell.
Choose a style and colour for the border and tap
OK
.
To change the background colour of a cell
, press
and select
Format
>
Background colour
. Choose a colour
and tap
OK
.
To show or hide gridlines, zero values, and headers
,
press
and select
Tools
>
Settings
. Select the items
you want to make visible in the worksheet and tap
OK
.
Chart sheets
To format a chart in detail
, press
and select
Format
. Select the object you want to edit. The
selection of settings varies depending on the type of
the chart.
Tip:
You can access some of the setting dialogs by
tapping the relevant item in the chart. For example, the
X-axis settings
dialog opens when you double-tap the
X-axis in the chart.
Font
– You can change the font type, size and colour. You
can also add bold, italic, underline, and strikethrough
formatting. You can raise or lower the text by selecting
superscript or subscript formatting. To see the effect of the
changes, tap
Preview
.
Chart
– You can select the chart type, make the chart
three-dimensional, and change the colour of the