Ingenious use of additional features of Excel cell boundaries

Source: Internet
Author: User

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 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. But when you enter the 12th digit, the cell will display the numbers 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.

You can, of course, click Column Header C and choose "column" and "Best fit" on the Format menu to enable the cell to automatically adjust the contents of the string displayed in the entire grid. 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.

Adjusts the width of the data column to fit the contents of the cell.

If you've entered column F from columns A. To make the cell fit automatically, first select A-g column, mouse over the black line in the middle of column head F and G, double-click. The width of all these columns will then 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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.