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 select 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). Alternatively, simply select the default style "Normal". |
| Tip: You can use the option Show 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 any name you like and confirm with OK. |
| 5. | The new cell style has now been created, and you can edit it individually as follows: |
To change the character format, click on the Character button. The program will display a dialog box, which is very similar to the dialog box for the ribbon tab Home | group Character (see Character format). |
| To change the cell format, click on the Cell button. The program will display a dialog box, which is very similar to the dialog box for 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 in 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 command Manage cell styles: 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 list on the left, change the style that you want to use as the basis for a new cell style, if necessary, before clicking on the New button.
You can use the selection Based on to subsequently change the assignment of the style basis for the created cell styles:
In the list on the left of the dialog box, first select the style to which you want to assign another style base. The Based on list shows you the basis on which the selected style is currently based. Here, you can change the style basis.
Note: If you want to change the Based on assignment for a cell style and you have not yet created a custom cell style, then this option cannot be selected yet because only the default styles are available so far. They have the "Normal" style as their basis, and this is a fixed assignment.
The option Based on will only be freely available to you once you have defined your custom new style and then selected it from the Styles list on the left.
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 only provide the cells with the number format "Currency" – and not change anything else. That's why all options except "Number format" are disabled in this style.
The settings in this section can be made individually for each style.
Note: For the default style "Normal", these options cannot be changed.
Using shortcut keys
If you need a cell style particularly 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 access the entry Manage cell styles. In the opened dialog box, select the desired style in 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.