Home >Topics >excel >Where to set excel column width

Where to set excel column width

藏色散人
藏色散人Original
2020-12-17 11:17:3082678browse

The excel column width is set in the column width dialog box. The specific setting method is: first open the Excel document that needs to be edited; then select the column that needs to be set; then right-click the selected area and select the column in the pop-up column. Just enter data in the wide dialog box to make settings.

Where to set excel column width

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

Operation method:

Open the Excel2010 document that needs to be edited, as shown in the figure:

Where to set excel column width

Select the column that needs to be set, here select A to Column H, note: You can select multiple columns or a single column, as shown in the figure:

Where to set excel column width

Method 1: Right-click the selected area and select [Column] from the pop-up menu Width], enter the data in the pop-up column width dialog box to set, and click [OK] to complete the setting. As shown in the picture:

Where to set excel column width

Method 2: Find the [Start] tab, as shown in the picture:

Where to set excel column width

In [Start] Find the [Cell] group under the tab, as shown in the figure:

Where to set excel column width

#Click the [Format] button in the [Cell] group, and the [Format] cascading menu will pop up. As shown in the picture:

Where to set excel column width

Find and click the [Column Width] button in the [Format] cascading menu, set it in the pop-up dialog box, and click [OK] after setting 】Complete the settings. As shown in the picture:

Where to set excel column width

Recommended: "Excel Tutorial"

The above is the detailed content of Where to set excel column width. 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
Previous article:How to use rand functionNext article:How to use rand function