Spreadsheet Formatting
Prev
Next

Chapter 3. Spreadsheet Formatting

Pamela Robert

Raphael Langerhorst

Cell Format

To change the format and appearance of selected cell(s), row(s) or column(s) use the Cell Format... option from the Format menu or from the right mouse button pop up menu.


Right mouse button context menu.

This will bring up the Cell Format dialog box which has several tabbed pages:

Data Formats and Representation


Data Format page.

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.

Fonts and Text Settings


Text page.

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.

Text Position and Rotation


Position page.

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.

Cell Border


Border page.

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

Cell Background


Background page.

The cell background pattern and color can be selected from the Background page.

Simply choose a desired pattern, then select the pattern color and the background color.

At the bottom of this page you can see a preview of the configured cell background.

Prev
Next
Home