To change the format and appearance of selected cell(s), row(s) or column(s) use the option from the menu or from the mouse button pop up menu.
This will bring up the Cell Format dialog box which has several tabbed pages:
The Data Format page of the Cell Format dialog box lets you control how the values of cells are displayed.
The top part of this page lets you select the format to be used when displaying numeric values, dates or times.
The lower part of the Data Format page lets you add a Prefix such as a $ symbol at the start of each item or a Postfix such as $HK to the end. You can also control how many digits are displayed after the decimal point for numeric values, whether positive values are displayed with a leading + sign and whether negative values are shown in red.
The Text page lets you select the font style, size and color, including some additional options like underlined or striked out text. The lower part of the page gives a preview of the selected text format.
From the Position page you can control the position of text within a cell by making suitable selections in the Horizontal and Vertical areas or by setting the Indent value. You can also choose to have the text appear vertically rather than horizontally, or even at an angle.
The Border page lets you set the appearance of the cell borders. If you have selected more than one cell you can apply different styles to the borders between the cells and that surrounding the selected area.
First select the pattern and color from the Pattern section of the Border page then apply that to different parts of the border by clicking on the appropriate button in the Border section, or on one of the Preselect buttons. The left hand button in the Preselect section will clear any previously applied border(s). Note that you can also add a diagonal strike-through line to the cell(s).