Home  >  Article  >  Topics  >  How to adapt row height after automatic line wrapping in excel

How to adapt row height after automatic line wrapping in excel

angryTom
angryTomOriginal
2020-03-04 11:54:1436700browse

When editing Excel content, sometimes the content of a certain column is too long. Usually we will set the column to automatically wrap, so that the content that is too long will automatically wrap and display. But sometimes after setting automatic line wrapping, the row height of the column remains unchanged, and the content displayed in the line wrapping cannot be fully displayed. So what should I do?

How to adapt row height after automatic line wrapping in excel

How to adapt row height after Excel automatically wraps lines

1. First, let’s take a look at the problems encountered when using Excel. This problem

recommended study: "excel basic tutorial"

How to adapt row height after automatic line wrapping in excel

2. The content of a certain column is too long, we set the column Automatic line wrapping

How to adapt row height after automatic line wrapping in excel

After setting automatic line wrapping, the long content is indeed displayed in new lines, but the row height does not adapt to the changes in the column content, resulting in incomplete display of the content

3. Solution:

Select the column, then click the "Start"-->"Format" menu at the top of Excel, and in the menu list that opens, click " Automatically adjust row height" menu item.

How to adapt row height after automatic line wrapping in excel

#4. The problem is solved. The row height of the row where the cell displayed in the column is adapted to the content height, and the entire table displays normally!

How to adapt row height after automatic line wrapping in excel

For more related tutorials, please pay attention to PHP Chinese website!

The above is the detailed content of How to adapt row height after automatic line wrapping 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