Home >Topics >excel >How to set vertical text in Excel table

How to set vertical text in Excel table

青灯夜游
青灯夜游Original
2019-06-04 16:16:15105510browse

When using Excel to edit a document, sometimes the entered text will be displayed from horizontal to vertical as needed. If it is too troublesome to enter the content cell by cell, then how to quickly and effectively change the text to vertical Row? The following article will introduce to you how to set the vertical text alignment in Excel tables. I hope it will be helpful to you.

How to set vertical text in Excel table

Steps to set vertical text in Excel table:

1. Open Excel, and then enter in the cell what you want to become Vertical text, as shown below

How to set vertical text in Excel table

2. Select the cell where the text is entered, right-click, and select the "Format Cells" item in the pop-up menu

How to set vertical text in Excel table

3. In the format cell window that opens, click the "Alignment" tab

How to set vertical text in Excel table

4. In the alignment setting page, click the "Vertical" button in the direction setting box, and finally click OK

How to set vertical text in Excel table

. Then you can see that the horizontal text entered above has become vertical. Already lined up.

How to set vertical text in Excel table

The above is the detailed content of How to set vertical text in Excel table. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn