Formatting your spreadsheet

To format a spreadsheet:

1. Select the cell, row, column or range you want to format.
   • To select a cell - Use the scroll keys and navigate to the desired cell.
   • To select a column - Select Options > Edit range > Column, then use left and right scroll keys to select the desired column.
   • To select a row - Select Options > Edit range > Row, then use up and down scroll keys to select the desired row.
   • To select a range - Select Options > Edit range > Block, then use the scroll keys, while holding the Shift key to select the desired range.
2. Select the type of formatting.
   • To specify number format - Select Options > Formatting. This allows you to specify the type of number format such as number, currency or date, number of decimals (if applicable) and whether to use a comma separator.
   • To specify alignment - Select Options > Alignment. This allows you to specify how to align the contents of the cell with respect to the cell border.
   • To specify font - Select Options > Style. This allows you to specify bold, italics, underline, font and text wrap.
   • To specify colour - Select Options > Colour. This allows you to specify the cell and text colour.

To edit a cell:

1. Select the cell you want to edit.
2. Select Options > Edit cell. This positions the cursor in the formula field. Use the left and right scroll keys to move within the cell.
3. Enter cell content.
   • To insert an operator - Select Options > Operators. This allows you to insert an operator where the cursor is positioned.
   • To insert a function - Select Options > Functions. Functions are grouped by category. First select a category, and then select a function. A list of the supported functions in listed in "Appendix A: Supported functions".
   • To insert a reference - Select Options > Select range. This allows you to insert a reference to another cell or range of cells.