It's easy to make your Excel cell automatically adjust the font size.

We will encounter an excessive number of words when we create an Excel spreadsheet. In general, we will choose to automatically wrap the same cell to increase the height to display more. More words, but sometimes the requirements of some forms are very strict, and the height is limited. In this case, the automatic line break function will not work. We can only display it in one line, so there is only a way to reduce the font size, but If there are too many columns and it takes too much time to adjust one frame at a time, then you need to let EXCEL automatically adjust the size of the font size. I will teach you how to use this function today, so go quickly.
For example, when you enter your home address, some home addresses are longer, which will make the contents of the cell not fully displayed on the screen, in order to make these cells The contents of the cell can all be displayed on the screen, and the cell size of the cell has to be redefined. If one-to-one adjustment is bound to greatly increase our workload, in fact, we can use the following method to automatically adjust the font size:
Select the cell area where you need to adjust the font size, and then select “Format → & rdquo; menu command, the “ cell format & rdquo; dialog box, select the "align" tab, in the "Text Control" box check the "Reduce the font fill" check box, click & ldquo ; OK & rdquo; button. Now, when we enter data in these cells, if the length of the input data exceeds the width of the cell, Excel will automatically reduce the size of the characters so that the data is all displayed in the cell.