单元格内手动强制换行

Pressing the +Enter keys inserts a manual line break. This shortcut works directly in the cell or in the input line. The input line can be expanded to the multi-line by the Down arrow button on the right.

如果希望输入文字时在单元格的右边缘自动换行，请按照以下方法设置:

选择输入文字时在单元格的右边缘处需要换行的全部单元格。
In Format - Cells - Alignment, mark the Wrap text automatically option and click OK.

For automatic wrapping in XLS files, the rows in question should be set to Optimal Height.

格式 - 单元格