Make Excel cells adjust font size automatically

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.