Home  >  Article  >  Software Tutorial  >  How to set cell size in excel2019_How to set cell size in excel2019

How to set cell size in excel2019_How to set cell size in excel2019

WBOY
WBOYforward
2024-04-24 13:55:111020browse

Are you having trouble setting Excel 2019 cell sizes? don’t worry! This article will provide you with detailed step-by-step instructions on how to adjust cell size easily. Whether you need to adjust a single cell or an entire column of cells, you can find a solution that works for you. Keep reading and we'll give you all the information you need to get it done quickly and efficiently.

1. Place the mouse pointer to the dividing line. Open the original file, and place the mouse pointer at the dividing line between column labels, here between the column labels of columns F and G. At this time, the mouse pointer changes into a double-headed arrow shape, as shown in the figure.

How to set cell size in excel2019_How to set cell size in excel2019

2. Drag to adjust the column width. ? Hold down the left mouse button and drag the column divider to the right,? During the dragging process, Excel will display the current column width value in real time, as shown in the figure.

How to set cell size in excel2019_How to set cell size in excel2019

3. The adjusted display effect. When dragging to the required width, release the left mouse button. At this time, you can see that the data in column F will not exceed the column width of the column, as shown in the figure.

How to set cell size in excel2019_How to set cell size in excel2019

2. Precisely set the column width

1. Select the column to be adjusted. Open the original file and select the column to be adjusted, such as column F, as shown in the figure.

How to set cell size in excel2019_How to set cell size in excel2019

2. Enable the column width setting function. ? Click the [Format] button in the [Cells] group under the [Home] tab,? Click the [Column Width] option in the expanded drop-down list, as shown in the figure.

How to set cell size in excel2019_How to set cell size in excel2019

3. Enter the column width value. The [Column Width] dialog box pops up,? Enter the exact column width value in the [Column Width] text box, such as [15.63],? After completing the input, click the [OK] button, as shown in the figure.

How to set cell size in excel2019_How to set cell size in excel2019

4. The column width effect of precise setting. At this time, you can see that column F has become wider and the data in the cell can be completely displayed, as shown in the figure.

How to set cell size in excel2019_How to set cell size in excel2019

3. Automatically adjust column width

1. Select the column to be adjusted. Open the original file? Select the column to be adjusted, here select column F,? Move the mouse pointer to the dividing line between columns F and G, and double-click when the mouse pointer changes to a double-headed arrow shape, as shown in the figure.

How to set cell size in excel2019_How to set cell size in excel2019

2. Check the effect after adjustment. At this time, you can see that the column width of column F is just enough to accommodate the content, as shown in the figure.

How to set cell size in excel2019_How to set cell size in excel2019

The above is the detailed content of How to set cell size in excel2019_How to set cell size in excel2019. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact [email protected] delete