Make Excel cells adjust font size automatically

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.

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.

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: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.