In life, no matter students or white-collar workers, they are often applied to office advanced application software. One of the more difficult is excel, which may be often used by financial department personnel, because they often need to make some forms, then they will encounter a situation where the text in the form will not change lines, and they will always walk horizontally to the right, busy people It's troublesome not to see the whole table. So what can we do to wrap the excel table? Let's take a look.
First, open the Excel application and input a line of words, such as' average growth rate of China's population '. At this time, we can see that the cell is too small and the text has been displayed horizontally to the right, which is not normal. We can select it and set the word wrap.
Another way is to find another cell, click it, right-click to set cell format, and the dialog box pops up with six options, namely 'number, alignment, font, border, pattern, protection'. The alignment we want to select. There are also four options in the alignment tab, namely 'text alignment, text control, right to left text direction and direction'. In this step, we want to choose text control. Under the text control, there are three options, 'Auto wrap, shrink font filling, and merge cells'. Obviously, we naturally choose auto wrap according to our own needs 。 At this time, you can see that when the cell width of 'average population growth rate of China' is not enough, it will automatically wrap lines, which looks more convenient.
If you want the entire sheet to wrap automatically, select all cells and follow the above method.