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 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"
2. The content of a certain column is too long, we set the column Automatic line wrapping
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.
#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!
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!