Home >Topics >excel >How to convert horizontal text into vertical text in Excel

How to convert horizontal text into vertical text in Excel

青灯夜游
青灯夜游Original
2021-01-05 14:20:25148467browse

Method: 1. In Excel, select the cells that need to be turned into vertical text; 2. Click the "Direction" button in the "Start" option editing area; 3. Click in the pop-up drop-down list "Vertical text" will do.

How to convert horizontal text into vertical text in Excel

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2016 version, Dell G3 computer.

How to change horizontal text into vertical text in Excel:

First open Excel on your computer

How to convert horizontal text into vertical text in Excel

Then enter the text you want in the cell, as shown in the figure below. Generally, we can only enter horizontal text.

How to convert horizontal text into vertical text in Excel

Then select the cell with the text entered, and click the direction button in the editing area, as pointed by the red arrow in the figure below.

How to convert horizontal text into vertical text in Excel

Then click [Vertical text] in the pop-up drop-down list, as shown in the figure below.

How to convert horizontal text into vertical text in Excel

Then we can see that the horizontal text in the cell changes to vertical text, as shown in the figure below.

How to convert horizontal text into vertical text in Excel

To read more related articles, please visit PHP Chinese website! !

The above is the detailed content of How to convert horizontal text into vertical text in Excel. 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