Automatic resizing of cells in Excel tables tutorial

Source: Internet
Author: User

In the process of using Excel, we tend to do the table according to the requirements, when the width of the cell is fixed, but the number of column characters vary. For example, when you enter a home address, some home address is longer, you will make the contents of the cell can not be fully displayed on the screen, so that the contents of these cells can be all displayed on the screen, you have to redefine the cell size. If one of the adjustments is bound to greatly increase our workload, in fact, we can use the following method to automatically adjust the font size:

Select the range of cells that you want to resize, select the format → cells menu command, click the Format Cell dialog box, select the Alignment tab, and in the Text control box, tick the Shrink font fill check box, and the OK button. Now, when we enter data in these cells, Excel automatically reduces the size of the characters if the data is entered longer than the cell width so that the data is displayed in the cell.

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.