FreeOffice: Creating and managing your own cell styles is not included in SoftMaker FreeOffice.
To create a custom cell style, proceed as follows:
| 1. | On the ribbon tab Home | group Format, click on the Cell styles  icon and choose Manage cell styles in the dropdown menu. |
| The dialog box Cell style opens. |
| 2. | Optional: In the Styles list in this dialog box, select the cell style on which your new style should be based (see also "Based on" below). Or simply select the default style "Normal". |
| Tip: You can use the Show option to determine whether all available styles should be displayed in the list – or only those already used in the current document. |
| 3. | Click on the New button. |
| 4. | Give the cell style whatever name you like and confirm with OK. |
| 5. | The new cell style has now been created, and you can modify it individually as follows: |
To change the character format, click on the Character button. A dialog box will be displayed, which is very similar to the dialog box from the ribbon tab Home | group Character (see Character format). |
| To change the cell format, click on the Cell button. A dialog box will be displayed, which is very similar to the dialog box from the ribbon tab Home | group Number (see Number format and the following section). |
| 6. | Click on Close to exit the dialog box (or on Apply first if you want to see the result of the cell style directly for the selected cells). |
The style is now defined and ready for use via the ribbon command Home | Cell styles .
You can create a different set of cell styles for each document; the styles are stored inside the document.
The selection "Based on"
When you create a new cell style, it is usually based on the "Normal" cell style. This means that the new cell style is based on the formatting of the "Normal" style. Changes to the formatting of the "Normal" style thus affect all other styles.
If you have already created cell styles and used them in the document, the following happens when you choose the Manage cell styles command: In the list on the left side of the dialog box, the style of the currently selected cell is selected as the basis. This may be the "Normal" cell style or another one. In the left list, change the style that you want to use as the basis for a new cell style, if necessary, before clicking the New button.
With the selection Based on, you can change the assignment of the style basis for the created cell styles at any time:
To do so, first select the style to which another style base is to be assigned from the left list in the dialog box. The Based on list shows you the base on which the selected style is currently based. You can change the style basis here.
Note: If you want to change the assignment of a cell style to Based on and you have not yet created a custom cell style, then this option cannot be selected at first because only the standard styles are available. These have unchangeably the style "Normal" as their base.
Only after you have defined your custom new style and then selected it from the left styles list, the option Based on is freely available for you.
Please note: Subsequent changes to the formatting of the style basis will also change all styles based on it. Only the formatting that you have already customized there will remain unchanged.
The "Format includes" section
In the Format includes section of the dialog box, you can specify exactly which of the formatting options to include when you apply the cell style.
For example, cell styles such as "Currency" should solely provide the cells with the number format "Currency" – and nothing else. That's why all options except for "Number format" are disabled in this style.
The setting in this section can be made for each style individually.
Note: For the default style "Normal" , these options cannot be changed.
Using shortcut keys
If you need a cell style frequently, you can assign it a shortcut key at any time. The advantage of this is that you can then enable the style very swiftly with one press of a key.
To assign a shortcut key to a style, use the Cell styles icon to open the Manage cell styles entry. In the opened dialog box, select the desired style from the list. Then click in the Shortcut key input field and press the desired key combination (starting with Ctrl or Alt).
Note: If you press a key combination that is already assigned, the current assignment is displayed below the input field Shortcut key. You should then press the Backspace keyÕ to delete your shortcut key and use a different key combination. Otherwise, you will overwrite the key combination for another style or even one of PlanMaker's commands.
We recommend that you always use key combinations that include the keys Ctrl and Shift since these are not usually assigned.