excel 单元格文本拼接_如何在Excel中的单元格中旋转文本

excel 单元格文本拼接

If you have a spreadsheet where the text in your column headings (not the lettered column headings) is longer than the text in the columns, and there are a lot of columns, you may want to rotate the text in your headings so the columns become narrower.

如果您有一个电子表格，其中列标题(而不是带字母的列标题)中的文本长于列中的文本，并且有很多列，则可能需要旋转标题中的文本，以便列变为较窄。

NOTE: We used Excel 2013 to illustrate this feature.

注意：我们使用Excel 2013来说明此功能。

This also allows you to fit more columns of data in a smaller area. To rotate the text in cells, first highlight the cells you that contain the text you want to rotate. Make sure the “Home” tab is active and click the “Orientation” button in the “Alignment” section of the “Home” tab (the button with the slanted text). Select an option to rotate the text. The icons to the left of the options show which way the text will rotate.

这也使您可以在较小的区域容纳更多的数据列。 要旋转单元格中的文本，请首先突出显示要旋转的文本所在的单元格。 确保“主页”选项卡处于活动状态，然后单击“主页”选项卡的“对齐”部分中的“方向”按钮(带有倾斜文本的按钮)。 选择一个选项以旋转文本。 选项左侧的图标显示文本旋转的方式。

The text is rotated in the chosen direction in the selected cells.

文本在选定的单元格中沿选定的方向旋转。

For more fine-tune control when rotating your text, highlight the cells containing the text you want to rotate and click the “Alignment Settings” button in the lower-right corner of the “Alignment” section of the “Home” tab.

要在旋转文本时进行更精细的控制，请突出显示包含要旋转的文本的单元格，然后单击“主页”选项卡“对齐”部分右下角的“对齐设置”按钮。

The “Format Cells” dialog box displays. The “Alignment” tab automatically displays. To rotate the text, click on any point along the semicircle in the “Orientation” box. The number of degrees of the rotation displays in the “Degrees” edit box. If you know the specific number of degrees you want to rotate the text, type the number directly into the “Degrees” edit box, or use the spinner arrow buttons to select a number.

显示“格式化单元格”对话框。 自动显示“对齐”标签。 要旋转文本，请在“方向”框中单击半圆上的任意点。 旋转度数显示在“度”编辑框中。 如果知道要旋转文本的特定度数，请直接在“度数”编辑框中键入数字，或使用微调箭头按钮选择一个数字。

If you want the text to be vertical in a cell (each character takes up one line), click the box to the left of the semicircle angle box in the “Orientation” but (the box with the word “Text” in a vertical format). The button turns black to show that the option is on and your text will look like the first cell in the image below once you click “OK” on the “Format Cells” dialog box.

如果要使文本在单元格中垂直(每个字符占用一行)，请在“方向”中单击半圆角框左侧的框，但单击“垂直”格式的带有“文本”字样的框)。 该按钮将变为黑色，表明该选项已打开，并且在“设置单元格格式”对话框中单击“确定”后，您的文本将看起来像下图中的第一个单元格。

To reverse the rotation of your text and display it normally, simply go back to the “Alignment” tab on the “Format Cells” dialog box and enter “0” (that’s a zero, not the letter “O”) in the “Degrees” edit box. To reverse vertical text, simply click the vertical text button on the “Alignment” tab so the button is not black.

要反转文本的旋转并正常显示，只需返回“设置单元格格式”对话框的“对齐”选项卡，然后在“度数”中输入“ 0”(即零，而不是字母“ O”) ”编辑框。 要反转垂直文本，只需单击“对齐”选项卡上的垂直文本按钮，以使该按钮不是黑色。

翻译自: https://www.howtogeek.com/227903/how-to-rotate-text-in-cells-in-excel/

excel 单元格文本拼接