Home>Article>Topics> How to wrap lines in Excel

How to wrap lines in Excel

藏色散人
藏色散人 Original
2019-08-21 13:42:50 19169browse

How to wrap lines in Excel

How to wrap the line?

The data in a certain cell in Excel is long, how do we automatically wrap it? In other words, line wrapping is done according to the rules, because automatic line wrapping is performed on top of the grid;

How to wrap lines in Excel

We can see an automatic line wrapping sign in the upper right corner of the start menu in the Excel table, select Then click on the cell to automatically wrap;

How to wrap lines in Excel

After the wrap mode is turned on, the cell will become what it is now. How to wrap other cells in the format? You can also click auto-wrap when swiping. This still doesn’t look perfect. For example, if the name has 2 or 3 characters, we adjust the position and then wrap it;

How to wrap lines in Excel

Special line breaks are actually just one step. Just hold down ALT enter, which is the carriage return in word. In excel, you cannot directly enter and you need to hold down the alt key at the same time;

How to wrap lines in Excel

By alt enter, we can distinguish each name with different lengths, which is very convenient. , let’s go and try it.

How to wrap lines in Excel

Related recommendations: "excel basic tutorial"

The above is the detailed content of How to wrap lines 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