Automatic hyphenation is not enabled by default in worksheet cells, but it can be enabled by the user. Of course, hyphenation is then only performed in cells that contain multi-line text.
In order to obtain hyphenation in cells, two steps are required:
Step 1: Enabling hyphenation in cells
In order for hyphenation to be performed at all in cells, you must first enable hyphenation for cells, as it is disabled by default. To enable it, proceed as follows:
| 1. | Choose the ribbon command File | group File management | Properties  . |
| 2. | Switch to the Options tab. |
| 3. | Enable the option Hyphenation. |
From now on, automatic hyphenation will also be performed in worksheet cells.
Note: This is a document option, thus you can enable or disable it individually for each document.
Step 2: Enabling the option Wrap text for cells
Hyphenations will only be performed in worksheet cells that have the option Wrap text enabled. This ensures that long text will be automatically wrapped to multiple lines if it doesn't fit into a single line.
To enable the option Wrap text, proceed as follows:
| 1. | Select the relevant cells. |
| 2. | Click on the group arrow in the bottom right corner of the ribbon tab Home | group Number. |
| Alternatively: Right-click to open the context menu and select the entry Cell. |
| 3. | Switch to the Alignment tab. |
| 4. | Enable the option Wrap text. |
Automatic hyphenation will now be performed in these cells (if they contain multi-line text) where required.