Excel table quickly adjusts the most appropriate row height and column width

When we are sorting the Excel document table, we often encounter too much text in the cell causing the content to be incomplete, or if the text is too small to cause extra whitespace, we need to adjust the row height or the column width to the appropriate size. But if it all depends on manual adjustment, it is also more troublesome. Is there any easier and quicker way? Of course, and it's available in both Excel2003 and 2007 versions. Here's an example.

Quickly adjust to the most appropriate column width

For example, column A is too wide and needs to be adjusted. We move the mouse between columns A and B, and when the mouse pointer changes to a double-headed arrow (the Red box section below), double-click the left mouse button and column A adjusts to the most appropriate column width immediately.

If you have more than one column to adjust, we can select the cells that need to be adjusted, select the menu "format-column-Most appropriate column width" To complete the column width adjustment of multiple cells.

Quickly adjust to the most suitable row height

Similar to the previous approach, such as the first row is too small, move the mouse to the first to second row, when the mouse pointer into a double-headed arrow, double-click the left mouse button, the first row immediately adjust to the most appropriate row height.

If you have more than one line to adjust, we can select the cells that need to be adjusted, select the menu "format-row-most appropriate row height" to complete the column width adjustment of multiple cells.