Home >Topics >excel >How to adjust table column width according to content in excel

How to adjust table column width according to content in excel

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-07-26 16:32:1912817browse

How to adjust table column width according to content in excel

For example: Let the wps table automatically adjust the column width of the table in the picture below.

How to adjust table column width according to content in excel

First hold down the left mouse button, drag the mouse on the list, and select the column to be adjusted.

How to adjust table column width according to content in excel

#Then double-click the left mouse button at the junction of the two column lists in the selection range.

How to adjust table column width according to content in excel

Related recommendations: "excel basic tutorial"

After double-clicking the mouse, the column width in the selection range will automatically be based on the content adjusted.

How to adjust table column width according to content in excel

In addition, you can also first select the cell range where you want to adjust the column width.

How to adjust table column width according to content in excel

Then click the [Rows and Columns] drop-down button as shown in the Home tab.

How to adjust table column width according to content in excel

Click the [Most Suitable Column Width] option in the drop-down menu to automatically adjust the column width.

How to adjust table column width according to content in excel

The above is the detailed content of How to adjust table column width according to content 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