Home >Topics >excel >How to add text when the slash header in excel is divided into two

How to add text when the slash header in excel is divided into two

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-05-26 16:56:5259701browse

Adding method: First open the excel table that needs to be operated, select the specified cell, and enter the required text; then click in the middle of the text to be separated, and hold down "ALT Enter" to divide the text into two lines; Finally, use spaces to push the specified text to the right and adjust the line height.

How to add text when the slash header in excel is divided into two

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

Enter text in the slash header, you will find that the text will not be automatically separated into upper and lower lines

How to add text when the slash header in excel is divided into two

We can click to separate In the middle of the text, press and hold the "ALT Enter key", the text will be divided into two lines

How to add text when the slash header in excel is divided into two

Use a space in front of the sales volume to push the text to the right, and then adjust the line height , so that the table is divided into two, and the text input is completed

How to add text when the slash header in excel is divided into two

Related learning recommendations: excel tutorial

The above is the detailed content of How to add text when the slash header in excel is divided into two. 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