Cell alignment

By default, Ability will align text to the left and numbers to the right of a cell. Both will be aligned to the bottom of the cell and each cell is formatted to sit on a single line (i.e. cell wrapping is off).

You can override the default alignment by using either the formatting bar or the Alignment command.

Using the formatting bar you can:

Alternatively, you can use the Alignment tab in the "Format" dialog box (select Cells in the Format menu or right-click and select Format Cells):

To set the horizontal alignment of the text, click on the button next to Left, Center or Right.

To set the vertical alignment of the text, click on the button next to Top, Center or Bottom.

If you want text that is too long for the cell to wrap round onto a line below within the cell (rather than writing on into adjacent cells), click on the checkbox next to Wrap Text. The cell will look something like this:

image\sp2.gif

A sample of the options you have chosen is given in the Preview box. When you have finished, click on the OK button and the text will be formatted to your specification.

See also:

Formatting the spreadsheet