Formatting

Fonts

The Font dialog box enables you to specify all basic font attributes including its name, size, weight, slant (the italic style), the underline and strikeout options and the font color.

To revert to the default settings, click the Reset button.

Style

You can use the following standard numeric styles and their options:

Alternatively, you can use a user-defined numeric format. To do this, simply enter the desirable style pattern in the Style dialog box. If you need to re-use it, you can save it as a new user style with a new name. To learn more about style patterns, please see how the standard styles are defined. For example, the accounting format is defined as:

_(\$* #,##0.00_);"($"* #,##0.00\);_(\$* \-??_);_(@_)

and the fraction format with the fixed denominator (4) can be defined as:

?\ ?/\4

User-defined formats allow you to specify font colors for numbers that meet some conditions. For example:

[green]#.#;[red]\-#.#;[blue]#.#;[gray]@

displays positive numbers in a green font, negative numbers in red, blue zeroes and gray text labels,

[red][<10]#0.00;[yellow][<=50]#0.0;[green][<400]##0;[magenta][>=400]#00

displays numbers less than 10 in a red font, numbers less or equal to 50 in a yellow font, numbers less than 400 in a green font and numbers greater or equal to 400 using a magenta font.

Color values can be expressed as RGB values (for example, [red][<10]#0.00 is the same as [#FF0000][<10]#0.00) or by one of the following color names:

black[#000000]maroon[#800000]
green[#008000]olive[#808000]
purple[#800080]
teal[#008080]gray[#808080]
silver[#C0C0C0]red[#FF0000]
lime[#00FF00]yellow;[#FFFF00]
blue[#0000FF]fuchsia[#FF00FF]
aqua[#00FFFF]white[#FFFFFF]

Alignment

The Alignment dialog box enables you to specify the following options: To revert to the default settings, click the Reset button.

Drop-down lists

You can use the Drop-down list dialog box to set the drop-down list format and/or to manage (create, edit, delete) lists in the current workbook.

When editing a field with some drop-down list attached to it, you can quickly choose some predefined cell value instead of re-typing it.
To set that format, simply choose an existing list or click the New List button.

To add list items, enter them in the List Items edit field: one item in one line.

If you choose the Append new items option, each unique value entered in the corresponding field(s) will be added to the list automatically.
If the Sort items option is not selected, the list will display all its elements in the same order as they were added/entered.
If the Multiple selection option is selected, you can select more than one list item. Use the Ctrl and Shift keys (along with clicking) to make such selections. Multiple item are copied to the corresponding cells as comma-separated lists. Multiple selections are not treated as new items and are not added to the list.

One list can be used by any number of fields in any table. You may create up to 100 lists in one database file. To move lists between files, you must copy/paste the data from the List Items edit field.