Teach you to automatically adjust Excel cell row height and column width

Do you think that the Excel unit aligning is narrower and the written text is often out of line? Or, the cell height is not enough, our text size is too large to show it? If you have these problems, just come and see how to automatically adjust the row height and column width of Excel cells. Let's take a look at the Excel2013 to automatically adjust the width of the column as an example to explain it.

Method One

1, open a worksheet with Excel2013, select the cell that we need to adjust the column width, switch to the Start tab, and select the AutoFit Column width option under format in the Cells group.

2, return to the worksheet, we will be able to see the previously selected cell column width has been automatically adjusted, the effect is as follows:

Method Two

Open a worksheet with Excel2013, select the cell that we need to resize the column, move the mouse to the upper-right corner of the column, and double-click the mouse when the pointer becomes the following state. This method can also make the width of the column automatically adjusted to get the same effect as the above image.

Tip: Both of the above are applicable to automatically adjust the row height of the cell, we can choose a method to achieve the automatic adjustment of the cell.