Nokia 7710 Formatting worksheets, Chartsheets, First select the cell or cells you want to format

Sheet

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 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.

Chartsheets

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.

102 Copyright ©2005 Nokia. All rights reserved.