Easy to move your Excel cell can also automatically adjust the font size

When we create an Excel spreadsheet, we will encounter an excessive number of words. In general, we will choose to automatically wrap the same cell to increase the height to display more words, but sometimes some tables The requirements are very strict, and the height is limited. In this case, the automatic wrap function will not work. We can only display it in one line, so we only have to reduce the font size, but if there are too many columns, one grid Adjustment is too time-consuming, and 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. The contents of these cells 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 want to adjust the font size, and then select “Format &rarr ; cell & rdquo; menu command, the “ cell format & rdquo; dialog box, select the “ align & rdquo; tab, in the "Text Control" box check the "Reduce the font fill" check box, Click the “OK” 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.