Use Excel cell boundary attach function

In Excel, users often have to deal with cells, rows, and columns. But have you ever noticed the boundaries of Excel cells? Do you take full advantage of the additional functionality that Excel provides on these boundaries?

Here we first take the "column" surgery. By default, Excel's column widths are limited to a certain length of string width. If you fill in a number in a cell with no more than 11 digits, the width of the corresponding cell automatically adapts to the length of the number, showing it all. The 3yz download station reminds you that when you enter the 12th digit, the cell will display the number in the grid with a scientific notation. As long as the number of digits in the cell does not exceed 30, its width can be automatically adjusted.

However, Excel does not provide similar functionality for strings. You can try typing "testing the width" in the C2 grid. At this point, if there is no string inside the D2, this line of string will be directly covered to D2. And if there are characters inside the D2, C2 will only display part of the original string on the screen.

Of course, you can make the cell automatically adjust the contents of the string in the full grid by clicking Column header c and selecting column and best fit width on the Format menu. But in fact there is a more convenient way in Excel: We assume that there is also a set of strings within the D2, C2 that long string of characters will only show a part. Double-click the black line between column headers C and D, and you will see that the width of column C has been automatically adapted to the character length in the grid.

If you've entered column F from columns A. To automatically fit the table cell width, first select the A-g column, the mouse is placed in the middle of the column head F and G on the black line, double-click. Remind everyone that the width of all these columns will be automatically adjusted.

Assuming column A is an empty column, you can press the left mouse button to hold down the black line between the column headers A and B. The following information appears below the mouse: (width): x.xx (xx pixel). The pixel information here can be used as a width reference when you add a table to a Web page. When you adjust the width of the column here, the following information is also updated in real time.

If you click on the black line between the outfits, the row height will be displayed. Double-click the black line and Excel automatically adjusts the row height.